SQLLoader and compensating for incorrect date values
Date: 21 Nov 2001 11:43:40 -0800
Message-ID: <78586940.0111211143.7f68bab5_at_posting.google.com>
I am using SQLLDR to load data from a fixed length file using this ctl
file:
but which won't work of course because it is evaluated
in the data source, occasionally some of the date columns have invalid
dates- not lways null, just bad or incorrect data, e.g.:
772660018SMITH SUSAN 691 N ROVER ROAD SAN JOSE 06311952
There is no 6/31/1952
LOAD DATA
772660018SMITH GEOFF 691 N ROVER ROAD SAN JOSE 1952
772660018SMITH SUSAN 691 N ROVER ROAD SAN JOSE
It's completely missing
I would prefer to just load these columns as null, but I'm not finding the correct syntax.
Any comments or suggestions?
I'd prefer not to edit the bad file - there are too many records.
-- Dick telnet://towel.blinkenlights.nlReceived on Wed Nov 21 2001 - 20:43:40 CET