Home » RDBMS Server » Server Administration » SQL loader for null DATE column
SQL loader for null DATE column [message #196042] Tue, 03 October 2006 15:49 Go to next message
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
)
Re: SQL loader for null DATE column [message #196044 is a reply to message #196042] Tue, 03 October 2006 15:55 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use the NVL function.
Please search board for examples.
Previous Topic: when resizing SQL database i get error ORA-03113
Next Topic: Method to upgrade a 9i Database to 10g on a very large Database
Goto Forum:
  


Current Time: Thu Dec 05 08:25:56 CST 2024