Hi,

I am trying to load a single Table in Oracle using sqlldr control file.

There are 9 source files and I want to skip the fist two rows in each of
the 9 files and load the remaining records.

When I use

OPTIONS(Skip=2) on line 1

it only skips the first 2 records of the first file. It does not skip
the first two records of the remaining 8 files.

Is there a way for the Loader to skip the first 2 rows of all the 9
files.

Thanks,
Ashim.


DB2 & UDB email list listserv db2-l LazyDBA home page