| Facing error while try to load data conditionally [message #154256] |
Fri, 06 January 2006 07:10  |
Nainar
Messages: 35
Registered: January 2005
|
Member |
|
|
Hi
I'm facing one error while doing condional load.
The control file is mentioned below and I'm getting this error
"
SQL*Loader-350: Syntax error at line 7.
Expecting "(", found "OR".
'' OR ACCNO <> ''
^
"
Control file:
LOAD DATA
INFILE *
INTO TABLE "TEST"
APPEND
WHEN ACC_PD_CTGY_CD <> '' OR
ACC_CO_NO <> '' OR
ACCNO <> '' OR
ACC_APPSYS_ID <> '' OR
ACC_SUB_NO <> ''
TRAILING NULLCOLS
(PTY_ID POSITION(1:11) INTEGER EXTERNAL,
CMPGN_ID POSITION(12:31) "UPPER(TRIM(:CMPGN_ID))",
CELL_ID POSITION(32:41) ,
BASELINE_DT POSITION(195:204) DATE "YYYY-MM-DD",
ACC_CO_NO POSITION(242:244),
ACC_PD_CTGY_CD POSITION(265:267),
ACCNO POSITION(268:288),
ACC_APPSYS_ID POSITION(289:291),
ACC_SUB_NO POSITION(292:312),
AUD_CREATED_DT SYSDATE
)
Kindly give any suggestion to avoid this error.
Thanks in advance.
-N
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
