Q: SQL*Loader

[Miki]

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

[Bricklen]

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.

[Miki]

Bricklen <bricklen-rem@yahoo.comz> wrote in message news:<tJeNb.14647$n44.5204@clgrps13>... 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.

no no, I don't need the present date/time, I need importing file's creation date...

thx anyway

[Bricklen]

Miki wrote: no no, I don't need the present date/time, I need importing file's creation date...
This timestamp then comes from where? Is your question really "how do I
get the file's creation timestamp"?

[Daniel Morgan]

Miki wrote:
Bricklen <bricklen-rem@yahoo.comz> wrote in message news:<tJeNb.14647$n44.5204@clgrps13>...Miki wrote:Hi,Is it possible to retreive from within sqlldr script the timestamp ofthe file imported, to be written in a table field?Example, my script looks like this:UNRECOVERABLELOAD 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 theidea.I spent hours searching on the Internet, cant beleive it is notpossible..Thx a lot for yours answers,Dinkotry:UNRECOVERABLELOAD 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 whilesince I used sqlldr so you'll have to test this. no no, I don't need the present date/time, I need importing file's creation date... thx anyway

If you want to date-time the file was created in the operating system
you will not get that with SQL*Loader. Either hard code it or start
writing your own C or Java to perform the task.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Miki]

Daniel Morgan <damorgan@x.washington.edu> wrote in message news:<1074182291.891999@yasure>... Miki wrote: Bricklen <bricklen-rem@yahoo.comz> wrote in message news:<tJeNb.14647$n44.5204@clgrps13>...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,>Dinkotry:UNRECOVERABLELOAD 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 whilesince I used sqlldr so you'll have to test this. no no, I don't need the present date/time, I need importing file's creation date... thx anyway If you want to date-time the file was created in the operating system you will not get that with SQL*Loader. Either hard code it or start writing your own C or Java to perform the task.

It can't be done with SQL*Loader, that was the fine answer.

thx a lot

Dinko