help in SqlLoader; NULLIF function

From: Venkatesh, Sankar (CAP, GEFA) <Sankar.Venkatesh_at_gecapital.com>
Date: Wed, 09 May 2001 10:22:23 -0700
Message-ID: <F001.002FE22D.20010509100727@fatcity.com>

Hi

Need help in SqlLoader

Using Solaris and Oracle 8.1.7

What is the syntax of NULLIF condition in "sqlldr ", when we have multiple null conditions for a column. I could not find the syntax for multiple NULLIF conditions on "Oracle8i_Utilities" manual .

I want to feed the column with NULL when the input data for the column TerminationDate (Data datatype ) is "000000" or "999999" or "731014" . The input data being in the form "YYMMDD"
I don't have problem running single NULLIF condition as in EffectiveDate

LOAD DATA
INTO TABLE AWW.Dealer
(

       Dealer                    POSITION(01:08) CHAR(8) ,
       EffectiveDate             POSITION(09:14) DATE(6) "YYMMDD"

NULLIF(EffectiveDate = "000000") ,
.
.
.

       StmtSeq                   POSITION(56:57) CHAR(2) ,
       TerminationDate           POSITION(58:63) DATE(6) "YYMMDD"

NULLIF(TerminationDate = "000000" OR TerminationDate = "999999" OR TerminationDate = "731014")
)

Any suggestion would be helpful .

Thanks in advance.

Sankar Venkatesh
GE Financial Assurance /Auto Warranty Services Dial Com:8*353-4242 ; 303-987-4242

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Venkatesh, Sankar (CAP, GEFA)
  INET: Sankar.Venkatesh_at_gecapital.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed May 09 2001 - 12:22:23 CDT