Re: SQL*Loader default field value

Hi.
The syntaks goes likes this:

PART_DESCRIPTION POSITION( 1: 30) NVL(:PART_DESCRIPTION ,'UNKNOWN'), best regards,
Asger

In article <6ia9j7$sr5$1_at_nnrp1.dejanews.com>, markjo_at_cwcinc.com says...
> I have a table in an Oracle 8 database that has three fields that make up the
> primary key. I am loading it with the following control file:
>
> LOAD DATA
> INFILE 'PARTDESCRIPTIONs.txt'REPLACE
> INTO TABLE PART_NUMBER_DESCRIPTIONS
> ( PART_DESCRIPTION POSITION( 1: 30),
> ITEM_CODE POSITION( 31: 42),
> PART_TYPE POSITION( 43: 43)
> )
>
> The problem is the Part_Type field could have just a space in it but the
> loader takes it as a NULL and throws the record out because the field cannot
> be NULL.
>
> There was a reply to another message about using :nvl(my field name, ' ') in
> the field description but I haven't found a syntax it likes.
>
> Any help would be greatly appreciated.
>
> Thanks in advance.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Sat May 02 1998 - 20:02:30 CEST