Q: SQL*Loader

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



Hi,

[Quoted] [Quoted] Is it possible to retreive from within sqlldr script the timestamp of [Quoted] 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 - 17:31:53 CET

Original text of this message