Re: SQL Loader question
From: <raju_pillai_at_my-deja.com>
Date: Sat, 30 Oct 1999 23:03:45 GMT
Message-ID: <7vftgg$7o8$1_at_nnrp1.deja.com>
Date: Sat, 30 Oct 1999 23:03:45 GMT
Message-ID: <7vftgg$7o8$1_at_nnrp1.deja.com>
David, trying giving the followinf clauses after each column name where
null value can appear EXTERNAL NULLIF b=BLANKS. Answer to ur second
question is :
TRAILING NULLCOLS tells SQL*Loader to treat any relatively positioned
columns that are not present in the record as null columns.
Give TRAILING NULLCOLS after ur into table <table name>
In short ur control file should look like
load data
> infile *
> append
> into table testing
TRAILING NULLCOLS
> fields terminated by ',' optionally enclosed by '"'
> (id
,b EXTERNAL NULLIF b=BLANKS
,c)
> begindata
> 1,null,'c'
> 2,3,'c'
I hope this helps
-Raju
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sun Oct 31 1999 - 01:03:45 CEST