Try trailing nullcols - see the manual for the specific placement (I don't
remember where offhand in the .ctl file it goes.)
--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)
Zhao Fu <scip6125_at_leonis.nus.sg> wrote in article
<6phkmr$45$1_at_nuscc.nus.edu.sg>...
> I am using SQL*Loader to load a medical datafile into an Oracle table.
The
> data format is like this:
> "Robert","19540823","lung and liver","19970418","Dr.Smith",...
>
> My control file is like this:
>
> load data
> infile 'somefile''
> badfile 'dt.bad'
> replace
> into table old_sum
> fields terminated by "," optionally enclosed by '"'
>
> (NAME,
> BIRTHDATE date 'YYYYMMDD',
> CANCER SITE,
> DEATHDATE date 'YYYYMMDD' ,
> DOCTOR_NAME,
> ...
> )
>
> but there are a lot of missing data in the field DEATHDATE, the field is
> thus empty, so the above record might be like this:
> "Robert","19540823","lung and liver","","Dr.Smith",...
>
> So, I added NULLIF DEATHDATE=BLANKS into the control file, but those
> records with missing DEATHDATE still cannot be loaded. In addition, if a
> character field data is missing, using NULLIF clause still cannot replace
> the column into null, but they turn out to be blanks with the maximum
> length of this varchar2 column.
>
> Anyone knows what's wrong with this?
>
> TIA
>
> Zhao Fu
> School of computing
> National Univeristy of Singapore
> zhaofu_at_comp.nus.edu.sg
>
>
>
>
> --
>
>
Received on Wed Jul 29 1998 - 18:33:59 CDT
