Re: Q: SQL*Loader

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.

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

thx anyway Received on Thu Jan 15 2004 - 10:53:28 CET