Re: [Q] Loading data file name through SQL*Loader

In <richard_avery-070895114143_at_nnsgm25.lon40.nt.com>, richard_avery_at_nt.com (Richard Avery) writes:
>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.

I'm not sure this is what you want but you can specify a constant in your .ctl file. For example:

    load data
    infile temp.prn
    into table temp

    (f1                position(1:10) char,
     f2                position(11:25) char,
     file_orig        constant 'TEMP.PRN')

M.Landa Received on Tue Aug 08 1995 - 00:00:00 CEST