Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!shaw.ca!news3.optonline.net!cyclone.rdc-nyc.rr.com!news.maxwell.syr.edu!sn-xit-03!sn-xit-04!sn-xit-01!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Daniel Morgan Newsgroups: comp.databases.oracle.tools Subject: Re: Q: SQL*Loader Date: Thu, 15 Jan 2004 07:59:27 -0800 Organization: ATS Message-ID: <1074182291.891999@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <58f0599d.0401140831.56968c0d@posting.google.com> <58f0599d.0401150153.7893354e@posting.google.com> In-Reply-To: <58f0599d.0401150153.7893354e@posting.google.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 62 Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:84326 Miki wrote: > Bricklen wrote in message news:... > >>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@x.washington.edu (replace 'x' with a 'u' to reply)