sql loader [message #71885] |
Tue, 28 January 2003 08:42 |
jinga
Messages: 116 Registered: January 2003
|
Senior Member |
|
|
I know that if the last column that is to be loaded has null values, we include TRAILING NULLCOLS in the control file. What verb we use if the first column from the flat file can be null or a value of 0.0??
|
|
|
Re: sql loader [message #71886 is a reply to message #71885] |
Tue, 28 January 2003 08:54 |
Debby
Messages: 3 Registered: June 2002
|
Junior Member |
|
|
You can use
NULLIF COLUMN_NAME=BLANKS
Or even if you leave this field wihtout any clause
also, it should be ok. It should in take the data
as null.
Does it solve your problem?
Debby
|
|
|