Re: Q: SQL*Loader

Miki wrote:

> Hi,
>
> Is it possible to retreive from within sqlldr script the timestamp of
> the file imported, to be written in a table field?
>
> Example, my script looks like this:
> UNRECOVERABLE
> LOAD DATA
> INFILE '\\Acz_Fin1\Vol3\vwdat\rdvk\SS45.txt'
> INTO TABLE MAT_ORIGINALNI_DIJELOVI_LOADER
> ( sifra POSITION(2:15),
> program POSITION(83:83),
> price POSITION(27:37)
> )
>
> I want to add the ss45.txt file's timestamp to the table, that's the
> idea.
>
> I spent hours searching on the Internet, cant beleive it is not
> possible..
>
> Thx a lot for yours answers,
> Dinko
try:

UNRECOVERABLE
LOAD DATA
    INFILE '\\Acz_Fin1\Vol3\vwdat\rdvk\SS45.txt'     INTO TABLE MAT_ORIGINALNI_DIJELOVI_LOADER

    (  sifra 	POSITION(2:15),
       program 	POSITION(83:83),
       price 	POSITION(27:37),
       tstamp_col "to_date(sysdate,'mm/dd/yyyy hh24:mi:ss')",

I think that the tstamp_col above may help, although it's been a while since I used sqlldr so you'll have to test this. Received on Wed Jan 14 2004 - 18:09:45 CET