Skip header rows with sql loader

Hi.

i have a problem with the skip-function of sql loader.

I use the command-line argument skip to skip 3 header rows. Also my control file looks like that:

LOAD DATA
--characterset WE8PC850
INFILE 'CSV_FILE'
APPEND
INTO TABLE data
WHEN (1) != '*'
TRAILING NULLCOLS
(
[...]
)

The Loader Control File contains a when-clause, which only inserts non-commented data-lines into table "data". So far it works, the skip-command skippes the first 3 lines and the control file starts processing the data-file. All lines which are commented out are skipped.

But today I tried it on another client. Here it works differently. First the when-clause is executed. After that the process skips the 3 lines for the skip-command.

An example, my file looks like this:

*Header1 <- i want to skip

Header2 <- i want to skip
*Header3<- i want to skip

Data1
Data2
*Data3 <- i want to skip

Data4
Data...

Thanks for any help.

Jörg Schönebaum Received on Fri Nov 04 2005 - 04:15:35 CST