Decode in SQLLoader .ctl file

From: Brian Peasey <bpeasey_at_doncarsys.com>
Date: 8 Jan 2002 08:29:37 -0800
Message-ID: <f044b9cc.0201080829.777bcef9_at_posting.google.com>



Hi,

[Quoted] [Quoted] 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 - 17:29:37 CET

Original text of this message