[Q] Loading data file name through SQL*Loader

We want to load the name of the data file in which a record was found into a table as part of a SQL*Loader run. This does not seem to be supported within a loader ctl file.

There is a value RECNUM which inserts the record number within the file, this seems fairly pointless if you cannot specify the name of the file too.

We are running under HP/UX 9 (Unix) and Oracle Financials Rel 10.5, the ctl file must be a separate entity and cannot be embedded within a shell script which could solve the problem.

Does anyone know of a way to achieve this under loader, otherwise I may have to resort to pre-processing the ctl file before calling it.

TIA,
Richard Avery

-- 
The above posting does not represent the views of Nortel in any way.