Sqlloader

Hi

I wish to load a table with sqlloader with data from a record that does not match the table record. The target table has three fields but the pipe demlimited data file has 8 fields. Is there a way to specify what field is inserted into the target field as with a fixed length sqlloader file?

To make things more complicated the third field in the target table needs to be populated with the sysdate.

Any ideas would be appriectaed, thanks

Rich. Received on Sun Apr 04 2004 - 04:55:38 CDT