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,
)
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