Re: SQL*LOADER Problem

From: Stuart Wood <stuart-wood_at_uiowa.edu>
Date: 1998/06/12
Message-ID: <35813EC9.350923D2_at_uiowa.edu>#1/1

Thomas Kyte wrote:

> Hows about sharing the .ctl file and one line of input data and the
> create table
> statement.
>

Good idea!

TABLE:

Name                            Null?    Type
------------------------------- -------- ----
KEY                                      CHAR(45)
CORP                                     CHAR(5)
FUND                                     CHAR(3)
ORG                                      CHAR(2)
DEPT                                     CHAR(4)
SUBDEPT                                  CHAR(5)
GRANTID                                  CHAR(1)
GRANTNO                                  CHAR(5)
GRANTSUB                                 CHAR(2)
INSTACCT                                 CHAR(4)
ORGACCT                                  CHAR(3)
DEPTACCT                                 CHAR(5)
FUNCTION                                 CHAR(2)
CENTER                                   CHAR(4)
MFDATE                                   CHAR(6)
ACCTTYPE                                 CHAR(1)
RPTCAT                                   CHAR(1)
RCURPRD                                  NUMBER(12,2)
RADJPRD                                  NUMBER(12,2)
RTODATE                                  NUMBER(12,2)
CBALFWD                                  NUMBER(12,2)
CCURPRD                                  NUMBER(12,2)
CADJPRD                                  NUMBER(12,2)
CTODATE                                  NUMBER(12,2)
ABALFWD                                  NUMBER(12,2)
ACURPRD                                  NUMBER(12,2)
AADJPRD                                  NUMBER(12,2)
ATODATE                                  NUMBER(12,2)
ECURPRD                                  NUMBER(12,2)
NCURPRD                                  NUMBER(12,2)
NADJPRD                                  NUMBER(12,2)
NTODATE                                  NUMBER(12,2)
USED                                     VARCHAR2(1)
USED_C                                   VARCHAR2(1)

.CTL File
load data
infile month94.dat
badfile month94.bad
discardfile month94.dis
replace
into table gl
fields terminated by ',' optionally enclosed by '"'

(key,
corp,
fund,

org,
dept,

subdept,
grantid,
grantno,

grantsub,
instacct,
orgacct,
deptacct,
function,
center,
mfdate,
accttype,
rptcat,

rcurprd,
radjprd,
rtodate,
cbalfwd,
ccurprd,
cadjprd,
ctodate,
abalfwd,
acurprd,
aadjprd,
atodate,
ecurprd,
ncurprd,
nadjprd,

ntodate)

SAMPLE DATA:
"10

0501730000000000000000020600000000400000","10","050","17","3000","00000","0","00000","00","0206","000","00000","40","0000","053197","E","J",0,0,0,0,0,0,0,0,0,0,0,0,0,0,-10606.33

"10

0501730000000000000000021100000000400000","10","050","17","3000","00000","0","00000","00","0211","000","00000","40","0000","053197","E","M",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0

(These are single lines in the file)

PROBLEM:
ntodate always gets NULL Received on Fri Jun 12 1998 - 00:00:00 CEST