Re: Rereading Input Files

[Alan Dalton <adalton@SIERRASYS.COM>]

Have you considered using an intermediate table to hold your data?

-----Original Message-----
From: C. Duncan Hudson [mailto:c_duncan_hudson@YAHOO.COM]
Sent: Wednesday, January 20, 1999 11:12 AM
To: Multiple recipients of list SQR-USERS
Subject: Rereading Input Files


Hi.  I have an SQR job that needs to process a file twice.  The job
reads in a flat file and inserts and updates rows in an Oracle
database based upon the information contained in the input file.  Then
because of the nature of the data in the file it must reread the input
file and update most of the rows (previously loaded) in the same
Oracle database.

The easiest way to accomplish this, I think, is to open the file and
loop through it.  Close the file and reopen it so that I can loop
through it again.  However, because of recent modifications that I
have been forced to include into the program the job no longer retains
the name of the filename that it just opened.  So I can't close and
reopen the file.  My question, therefore, is can I reread the already
opened file (position the pointer at the top of the file), and if so
how?

Thanks in advance for any help / ideas that you may be able to provide.


C. Duncan Hudson
Dynax Solutions




_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com