Re: Using NULLIF in SQL*Loader

From: Russell Reed <rreed_at_cei.net>
Date: 1997/09/19
Message-ID: <01bcc4ff$05edb3e0$7f276e87@rreed.conway.acxiom.com>#1/1

John-Paul <meadj01_at_popmail.med.nyu.edu> wrote in article <B045B2E5-63812F_at_128.122.205.107>...
> 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?

How about NULLIF(NOT cls BETWEEN 0 AND 5).

Russell Reed Received on Fri Sep 19 1997 - 00:00:00 CDT