Re: Q: SQL*Loader

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1074182291.891999_at_yasure>...
> 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.

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

thx a lot

Dinko Received on Fri Jan 16 2004 - 12:22:30 CET