SQLLDR: Multipul NULLIF for column.

From: Troy <troy_at_morpheus.NO_SPAM!.net>
Date: Fri, 14 May 2004 00:01:06 GMT
Message-ID: <2j28a0pskdsg1ca811893b3ufrk6e658i8_at_4ax.com>

[Quoted] [Quoted] 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! Received on Fri May 14 2004 - 02:01:06 CEST