SQLLDR - How to set value based on the infile?

From: Cynthia Peng <peng_cynthia_at_hotmail.com>
Date: 3 Jul 2003 12:38:36 -0700
Message-ID: <b37b77ca.0307031138.409fc771@posting.google.com>

I am loading data into a table from multiple files. How do you set value to a field based on the particular source file. Didn't find the answer at the first look at the 9i Database Util doc. Any insight/comment is greatly appreciated.

===================example=======================================

load data

infile "F:\a\formats.ing"  "str"
infile "F:\b\formats.ing"  "str"
infile "F:\c\formats.ing"  "str"
infile "F:\d\formats.ing"  "str"

append

into table tmp_formats
 (notif_fmt position(6:8) , name CONSTANT 'value_based_on_infile') Received on Thu Jul 03 2003 - 14:38:36 CDT