Re: Skip header rows with sql loader

Jörg Schönebaum wrote:
> 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.

So it does this?
*Header1 <- WHEN skip
 Header2 <- skip command (1)
*Header3<- skip command (2)
 Data1<- skip command (3)
 Data2
 Data...

Not sure I can help, but, is that the problem? What client platform? What version of ORACLE??

[]
>
> Thanks for any help.
>
> Jörg Schönebaum
Received on Tue Nov 15 2005 - 19:36:08 CET