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,
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