Problem loading text data into Oracle8

From: <hillt_at_doimex1.sill.army.mil>
Date: Tue, 29 Dec 1998 18:47:41 GMT
Message-ID: <76b84c$2kd$1_at_nnrp1.dejanews.com>

[Quoted] I have a 581MB text file, fixed length records (VSAM files from IBM MF) that [Quoted] contains several date fields as YYMMDD that may be either blanks or '000000'. [Quoted] How can I use the SQL*Loader to load these records? If I try this:

ETS_DATE POSITION(xx:yy) DATE "YYMMDD" NULLIF ETS_DATE=BLANKS

then the records with '000000' get rejected.

If I try

ETS_DATE POSITION(xx:yy) DATE "YYMMDD" NULLIF ETS_DATE="000000"

then (obviously) the blank records get rejected.

There does not appear to be any way to use an OR condition here.

Is there a way to do this, or will I have to break down and write a program?

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 29 1998 - 19:47:41 CET