SQL loader (SQLLDR73) "Decode" statement

[Quoted] I am having trouble importing a flat field into ORACLE with the SQLLDR73 tool. I am trying to decode one of the fields that is coming ininto 1 of 4 values, with everything else being defaulted to value '99'.

How do I tell SQLLDR that when the field is blank, leave it bank??

This does not work :

VISIT_TYPE_CD            POSITION(21:23)         CHAR
			"decode(:visit_type_cd,
                        null,''
			'ED','01',


                        'RET','02',


                        'UNS','03',


		        '99')",

but this works just fine, but does not do what I want:
VISIT_TYPE_CD            POSITION(21:23)         CHAR
			"decode(:visit_type_cd,
               		'ED','01',


                        'RET','02',

                        'UNS','03',


                        '99')",

Any ideas????

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 15 2000 - 21:33:01 CET