Re: sqlloader Question

> ttroccol_at_motown.ge.com (Ted M. Troccola X4721) writes:
>
> I am using sqlloader to get data from a data file.
> The data file has like 10 columns in it.
> I am loading four tables which use some, but NEVER all, of the
> columns in the datafile.
>
> So, I have to extract only these certain columns for certain tables.
>
> Can this be done?
>
>>>>

If you have fixed length fields, you may be able to use position clause in defining the columns to be loaded (refer to utilities users guide).

If you have variable length fields delimited by a certain field separator, you can use cut or awk to split the file first into required number of files. Thean load it.

I hope you are using UNIX.

Ganesh Puranik,
Consultant, Surya Systems, Inc. Received on Thu May 18 1995 - 00:00:00 CEST