Re: Using NULLIF in SQL*Loader

The following would accomplish the purpose

  cls position(*) char "decode(:cls, '0', 0, '1', 1, '2', 2, '3', 3, '4', 4, '5', 5, null)"

John-Paul wrote:
>
> I am trying to load an Oracle7 database with data from a text file.
> One of the columns contains either numerical or character data.
> I would like to ignore the character data, and only load the numerical data
> (between 0 and 5).
> I placed a statement in my SQL*Loader '.ctl' file like this:
>
> cls POSITION(*) INTEGER EXTERNAL NULLIF (cls NOT BETWEEN 0 AND 5),
>
> I get the error:
>
> SQL*Loader-350: Syntax error at line 10.
> Expecting = or "<>", found "NOT".
> cls POSITION(*) INTEGER EXTERNAL NULLIF (cls NOT BETWEEN 0 AND 5),
>
> Does anyone see the problem here?
 

-- 
Frank Hubeny            
fhubeny_at_ntsource.com            
Wheaton, IL 60187