Modifying Data inserted with SQL Loader

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 Wed Apr 24 2002 - 14:03:38 CDT