Re: SQLLOADER: bypassing columns in the CSV file ???

gelewyc_at_nyct.com (george lewycky) wrote in message news:<68aecc05.0301080800.58bdde0_at_posting.google.com>...
> Hi everyone,
>
> I used Excel to create a CSV file, but some columns were derived
> using two columns and I DONT want those derivative fields used when
> i run sqlldr.
>
> How can I tell sqlldr to bypass fields A & B but not C as
> shown below for column ORIG_SYSTEM_ADDRESS_REF ?
>
>
>
> A B C
> CUST 1002 CUST1002
> CUST 1003 CUST1003
> CUST 1004 CUST1004
> CUST 1005 CUST1005
>
If fields A and B are always the same size, you can include a line in your control file which tells sqlldr to start at a specific position on the line. Lets say that A and B are both 4 digits and that your file is comma-delimited. Your control file would start as follows:

LOAD DATA
APPEND INTO TABLE table_name
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' (
field_name POSITION(11) CHAR,
blah,
blah
)

Allowing for the two commas, the loader should start at position 11 on the line.

Good luck.

>
> Thanks in advance
>
> George Lewycky
> ny city transit
> brooklyn, nyc
Received on Thu Jan 09 2003 - 20:39:11 CET