SQL*Loader default field value

From: <markjo_at_cwcinc.com>
Date: Thu, 30 Apr 1998 11:41:11 -0600
Message-ID: <6ia9j7$sr5$1_at_nnrp1.dejanews.com>

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 Thu Apr 30 1998 - 19:41:11 CEST