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@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 Sat Oct 30 1999 - 18:03:45 CDT