Re: SQLLDR: Multipul NULLIF for column.

Troy <troy_at_morpheus.NO_SPAM!.net> wrote in message news:<2j28a0pskdsg1ca811893b3ufrk6e658i8_at_4ax.com>...
> I want to use multipul NULLIF statements in my sql loader control
> file. For example, I have a text file, tab delimited, and one of the
> columns of data that I am interested in has a float value. However,
> this float value could also be NA, or NL, or NS depending on why that
> value wasn't able to be generated.
>
> So my control file looks like this:
>
> <snip>
> F28 FILLER,
> F29 INTEGER EXTERNAL,
> F30 FILLER,
> F31 FILLER,
> F32 FLOAT EXTERNAL NULLIF (F32="NA"),
> F33 FILLER,
> F34 FILLER
> <snip>
>
> I need to add more than one NULLIF statement for the F32 column. Is
> this possible?
>
> Thanks!
Try the following;

[Quoted] F32 position(*) FLOAT "decode(:F32, 'NA', null, 'NL', null, 'NS', null, null)"

Davis Swan
www.sqlmagic.com Received on Tue May 18 2004 - 01:15:34 CEST