Re: SQL Loader Exclude lines from datafile

[Quoted] "Bernhard Graeuler" <fuerspam_at_gmx.de> wrote in message news:b13381$urg1s$1_at_ID-49408.news.dfncis.de...
>
> Now I need a control file for the SQL*Loader that filters out the
> repetitions of the fieldnames. Theoretically that would be easy, because
> they start with a '*', but I don't now how to do it. I thought about a
"WHEN
> (1) != '*'" Statement, but as far as I know the (1) means the first field
of
> the table, what is wrong...
> This is what I have so far:
>

(1) means the first character character of the record, so WHEN (1) != '*' should work fine.
Why do you say it's not correct ?

Bye,
Flavio Received on Mon Jan 27 2003 - 12:14:38 CET