If I have a column in a dat file that for certain records is not there
how can I tell the sql loader
To make that field a null and go to the next field. The ctl file is
below. The problem is with
Trans_id. In some of the records in the dat file this field is a tab
(no data). What this does is move all of the other data over 1 field in
those records. Any advice.

Thanks
Les
813-604-9694



LOAD DATA

INFILE 'C:\Data_Loader\EERS_REVO_ORG2.DAT'

INTO TABLE SEC_ADM.EERS_REVO2

INSERT

FIELDS TERMINATED BY X'09' OPTIONALLY ENCLOSED BY ',' TRAILING NULLCOLS
(request_id,
create_date date "MM/DD/YYYY" NULLIF create_date=blanks,
created_by,
name,
geid NULLIF geid=" ",
RITS_ID,
status_cd,
type,
login_id,
app_nm,
app_id,
multi_isa,
tran_id NULLIF tran_id = "",
tran_descr NULLIF tran_descr=" ",
entitle_cd,
isa_group_name,
smtp_email,
phone NULLIF phone=" ",
isa_review_date date "MM/DD/YYYY HH24:MI:SS" NULLIF
isa_review_date=blanks)

Oracle LazyDBA home page