SQLLOADR, skipping Fields

Hi..All,

   I am downloading the data from sybase to load into Oracle DB. Now, all the data fields in the data file are not  required & its a variable length record. If the record looked like :

 Field1|Field2|field3|field4|field5|field6|field7|field8

 I want to pick only say, field1, field3, field7 & Field8. Is there any option in SQLLDR where I can specify which  fields are needed.

• Positions won't work as its a variable length record.

 Thanks a lot in Advance.

 Regards,

 Praveen Mohanan

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jul 14 2000 - 00:00:00 CDT