Re: SQL Loader question

does the table into which your are loading this data permit null in this column?

<raju_pillai_at_my-deja.com> wrote in message news: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 Mon Nov 01 1999 - 19:44:47 CET