Re: Q: SQL*Loader

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 15 Jan 2004 07:59:27 -0800
Message-ID: <1074182291.891999_at_yasure>


[Quoted] Miki wrote:

> Bricklen <bricklen-rem_at_yahoo.comz> wrote in message news:<tJeNb.14647$n44.5204_at_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

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_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Thu Jan 15 2004 - 16:59:27 CET

Original text of this message