SDLLDR Question

[Quoted] I am trying to have a dual condition on a field when loading it using a [Quoted] control file.

Ok, the file is not a comma delimited file. It is fixed with and fixed [Quoted] column. Here is a cut from my control file:

DATE_BILLING POSITION(118:125) DATE(8) "YYYYMMDD" NULLIF (DATE_BILLING = " "),

I changed it to this:

DATE_BILLING POSITION(118:125) DATE(8) "YYYYMMDD" "decode(DATE_BILL ING, '00000000' null, ' ', null)",

I got this error message:

SQL*Loader-417: SQL string (on column DATE_BILLING) not allowed in direct path.

Any ideas?

Thanks,

Arthur
amerar_at_ci.chi.il.us

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 21 1999 - 17:18:42 CEST