| Re: sql loader [message #69157] |
Fri, 09 November 2001 13:37 |
Srinivas
Messages: 138
Registered: June 2000
|
Senior Member |
|
|
Hi,
problem outline: in my input file, in one of the columns I have
X'25'in the middle of the last column like SBA COLLECTIONS REPORT.TERMINATED EFF 05/31/2001.WMS
(the dots you see in the middle ar not full stops, they are X'25').
and my load ctl file goes like this
OPTIONS (ERRORS=0, ROWS=300, DIRECT=TRUE, SKIP=0)
LOAD DATA
REPLACE
INTO TABLE "ICPC"."TCVSH_CV_STS_HIST"
FIELDS TERMINATED BY ","
OPTIONALLY ENCLOSED BY '|'
(
"FK_CNVR_PURCH_IK" CHAR(46),
"FK_CNVR_CNT_SEQ_NB" CHAR(46),
"FK_CNVR_CNT_VER_NB" CHAR(46),
"CRTE_DT" DATE "YYYY-MM-DD",
"CRTE_TM" CHAR(8),
"CRTE_USR_ID" CHAR(8),
"STS_CD" CHAR(12),
"ROW_STS_CD" CHAR(1),
"ACTVY_EFF_DT" DATE "YYYY-MM-DD",
"DLNQ_LTR_TP_CD" CHAR(4),
"TERMN_NOTC_SNT_IN" CHAR(1),
"VER_EFF_END_DT" DATE "YYYY-MM-DD",
"KFHP_OFR_CNVR_IN" CHAR(1),
"FK_ACTR_ACT_CAT_CD" CHAR(12),
"FK_ACTR_ACT_RSN_CD" CHAR(12),
"ROW_VER_NB" CHAR(46),
"CVSH_CMT_TX" CHAR(254)
)
When I try to load I get the following error
Record 3: Rejected - Error on table "ICPC"."TCVSH_CV_STS_HIST", column "CVSH_CMT_TX"
ORA-02362: Logical record ended - second enclosing character not present
This is because it is taking X'25' as the file of the record/column.
Any suggestions as to how I load these data thru SQL*LOADER.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
