We are trying to load comma delimited data in which the
character variables are also surrounded by double quote marks
into a database using Rel 8.0.5.0.0 of SQL Loader for WIN 95 into
the Oracle 8 data base (NT). None of the records loads. The
reason given is that the criteria in two when statements is
not met - however the data shows it is
In the log, the length of the data elements shows an asterisk.
Some of the code follows:
The data follows:
"01","2000","02","102","22",3333,3,3,3,3
"05","2000","05","104","24",10424,32,5,67,234
"06","2000","06","099","20",1234,3,5,78,89
What are we not doing correctly?
John Winston
California Dept of Aging
Sacramento
--------------------------------------------------------------------------------
[sig][/sig]
character variables are also surrounded by double quote marks
into a database using Rel 8.0.5.0.0 of SQL Loader for WIN 95 into
the Oracle 8 data base (NT). None of the records loads. The
reason given is that the criteria in two when statements is
not met - however the data shows it is
In the log, the length of the data elements shows an asterisk.
Some of the code follows:
Code:
OPTIONS (bindsize=118864)
LOAD DATA
INFILE 'c:\oradocs\MANAGE\cbspdex.dat'
BADFILE 'C:\oradocs\manage\cbsp107.bad'
DISCARDFILE 'c:\oradocs\manage\cbsp107.dis'
APPEND
INTO TABLE administrator.cbsp107
WHEN (servcat = "101")
and (funsrce = "21")
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(TRTYPE CONSTANT 'N', psa_no, SYR, SMO, servcat, funsrce, totexp,
matcsh, matcik, proginc, othfund TERMINATED BY " ",
dateproc SYSDATE,
trans_used CONSTANT 'N')
INTO TABLE administrator.cbsp107
WHEN (servcat = "102")
and (funsrce = "22")
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(TRTYPE CONSTANT 'N', psa_no, SYR, SMO, servcat, funsrce, totexp,
matcsh, matcik, proginc, othfund TERMINATED BY " ",
dateproc SYSDATE,
trans_used CONSTANT 'N')
INTO TABLE administrator.cbsp107
WHEN (servcat = '103')
and (funsrce = '23')
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(TRTYPE CONSTANT 'N', psa_no, SYR, SMO, servcat, funsrce, totexp,
matcsh, matcik, proginc, othfund TERMINATED BY " ",
dateproc SYSDATE,
trans_used CONSTANT 'N')
"01","2000","02","102","22",3333,3,3,3,3
"05","2000","05","104","24",10424,32,5,67,234
"06","2000","06","099","20",1234,3,5,78,89
What are we not doing correctly?
John Winston
California Dept of Aging
Sacramento
--------------------------------------------------------------------------------
[sig][/sig]