Re: Decode in SQLLoader .ctl file

nm..got it.

bpeasey_at_doncarsys.com (Brian Peasey) wrote in message news:<f044b9cc.0201080829.777bcef9_at_posting.google.com>...
> 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 - 23:19:08 CET