Re: Modifying Data inserted with SQL Loader

From: Jonathan Gennick <listmail_at_gennick.com>
Date: Sat, 27 Apr 2002 15:59:47 -0400
Message-ID: <4o0mcuop9638krdqeubib8sru90u4m8bi4@4ax.com>

You might be able to use the DECODE function:

othernumber "DECODE(4,12,5,15...)"

Jonathan Gennick --- Brighten the corner where you are mailto:jonathan_at_gennick.com
http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com

On 24 Apr 2002 12:03:38 -0700, pstryjew_at_att.net (pstryjew) wrote:

>Hello,
>
>I have data in a flat file that I am using SQL Loader to load into a
>table.
>
>I'm adding an offset to one of the values and that is straight forward
>in the control file. I would also like to modify another value based
>on it's current value (if-then or look up table). I can't find out if
>this is possible.
>
>Control file:
>
>mynumber "TO_NUMBER(:mynumber) + offset",
>othernumber [if 4 insert 12, if 5 insert 15, etc]
>
>Pete Stryjewski
>pstryjew at att dot net
Received on Sat Apr 27 2002 - 14:59:47 CDT