Re: Decode in SQLLoader .ctl file
From: Richard Kuhler <noone_at_nowhere.com>
Date: Tue, 08 Jan 2002 20:35:03 GMT
Message-ID: <XJI_7.90983$AI.22248934_at_typhoon.san.rr.com>
Date: Tue, 08 Jan 2002 20:35:03 GMT
Message-ID: <XJI_7.90983$AI.22248934_at_typhoon.san.rr.com>
I believe you need the pl/sql expression in double quotes (and the field as a host variable). Something like.....
PROD_RATE_LOCK_DATE POSITION(49:56)
"TO_DATE(DECODE(:PROD_RATE_LOCK_DATE, '00000000', '01011900',
:PROD_RATE_LOCK_DATE), 'MMDDYYYY')"
Richard
Brian Peasey wrote:
>
> Hi,
>
> I need a bit of help with my .ctl file. I'm trying to trap for a bad
> date of "00000000" and replace it with Jan 01,1900. Here's my line.
>
> PROD_RATE_LOCK_DATE POSITION(49:56) DECODE(PROD_RATE_LOCK_DATE,
> "00000000", "01011900") DATE "MMDDYYYY",
>
> Any suggestions greatly appreciated.
>
> Best Regards,
> Brian
Received on Tue Jan 08 2002 - 21:35:03 CET