Re: Filenames using SQL Loader

hello Jason,

here's a shell script; it gets the data from a staging table and then uploads it to the main table using a procedure - which passes the filename to the main table (or logging table) !

  export LOADFILE= xxx.dat
  sqlload usernm/$1 control=loadxx.ctl data=$LOADFILE

  sqlplus usernm/$1 <<-eof
  set serveroutput on
  exec uploadproc('$LOADFILE')
  eof

cheers,

     Roelof Schierbeek

R.Schierbeek, DBA

Jason Rowski <jasonrowski_at_yahoo.com> wrote...
>
> I have a daily batch job which is loading orders from 230 files. I am
> using SQLLDR to load these order files. I need to store the name of
> the filename in the column FILE_NAME in the order table IPX_ORDERS.
> How can I do this ?
>
> Thanks
> Jason
Received on Fri Mar 14 2003 - 13:50:04 CST