Q: SQL*Loader

From: Miki <dinko96_at_yahoo.com>
Date: 14 Jan 2004 08:31:53 -0800
Message-ID: <58f0599d.0401140831.56968c0d@posting.google.com>

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 Received on Wed Jan 14 2004 - 10:31:53 CST