OraFAQ Forum: Server Administration » SQL loader for null DATE column

Home » RDBMS Server » Server Administration » SQL loader for null DATE column

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL loader for null DATE column [message #196042]

Tue, 03 October 2006 15:49

catpurr
Messages: 11
Registered: November 2005

Junior Member

I am using sqlldr to load file contains null at DATE column. It doesn't allow me to load these records even I use trailing nullcols. please help. Here is my control file:

LOAD DATA
INFILE 'P:\Baseline_3.txt'
BADFILE 'P:\Baseline.bad'
DISCARDFILE 'P:\Baseline.dsc'

INTO TABLE "MM"."BASELINE"
REPLACE

FIELDS TERMINATED BY X'9'
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS

(IMAGEID
,
COLLECTIONDATE DATE "dd/mm/yyyy"
,
DATEOFENTRY DATE "MM/DD/YYYY"
,
SEX
,
ETHNICITY
,
PRIINDI
,
BLOODGROUP
,
RHESUS
,
RECIPIENTCMV
,
DONORCMV
,
LVAD
,
INDUCTION
,
HYPERTENSION
,
DIABETES
,
RENALDISEASE
,
HYPERLIPEDEMIA
,
NUMBIOPSIES
,
NUMREJECTIONS
,
MALIGNANCY
,
BASELINEECHO
,
ECHODATE DATE "MM/DD/YYYY"
,
ECHODATEFLAG
,
ECHOLVEF
,
ECHOLVEFFLAG
,
TRIREGURG
,
MUGA
,
MUGADATE DATE "MM/DD/YYYY"
,
MUGADATEFLAG
,
MUGALVEF
,
MUGALVEFFLAG
,
LEFTVENT
,
LEFTVENTDATE DATE "MM/DD/YYYY"
,
LEFTVENTDATEFLAG
,
LEFTVENTLVEF
,
LEFTVENTLVEFFLAG
,
ANGIOGRAM
,
ANGIODATE DATE "MM/DD/YYYY"
,
VESSELSTENOSIS
,
IVUS
,
IVUSDATE DATE "MM/DD/YYYY"
,
IVUSCOMMENTS
,
MODIFIEDDATE DATE "MM/DD/YYYY"
,
MODIFIEDBY
)

Report message to a moderator