| SQlloarder trailing nullcols option [message #19904] |
Wed, 17 April 2002 07:09  |
Joan
Messages: 36
Registered: February 2002
|
Member |
|
|
I have control file with trailing nullcols option
My data file has some missing records in the middle and then one records at the end. I am getting errors loading the files.
eg 1 2 3 4 7
How does the trailing nulcols option works. the file is tab separated . You can't have field missing in the middle of the records?
|
|
|
|
|
|
| Re: SQlloarder trailing nullcols option [message #19920 is a reply to message #19904] |
Thu, 18 April 2002 06:20  |
André ALIMBA
Messages: 16
Registered: April 2002
|
Junior Member |
|
|
The TRAILING NULLCOLS clause causes SQL*Loader to treat any fields that are missing at the end of a record as null.
If the last field does not contain data, during the loading (inserting data), this clause (TRAILING NULLCOLS) says to load a 'null value'.
IF the last field is not present for every record, this clause says to load a null value instead of rejecting the record when the number of data values is less than the number of fields define in the control file (xxxx.CTL).
IF TRAILING NULLCOLS is not specify, all recordswith no data for the last field are going to be rejected.
Source : SQL*LOADER Control File Reference (OnLine Doc).
Other :
If you loose some records, verify if you are inserting null value in the field define not null.
In your sqlldr commande, try to use the log clause ...
André ALIMBA, Chef de Projet BEAC (Cameroun).
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
