Re: SQL*Loader default field value

Hi,
PART_TYPE. Is it defined as CHAR NOT NULL or VARCHAR2? This could be the prob. With CHAR it should stay blank.
bobH

markjo_at_cwcinc.com wrote:
>
> 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 Fri May 01 1998 - 01:30:54 CEST