Re: Changeing records in a big file

[John P Carr <jpcarr@xxxxxxxxxxxx>]

I would use SQLRPGLE to do it.   I think even without a key,  SQL can scream
thru the file doing a Full Data Base scan of all the records in a LOT less
time than reading a record in to an RPG program for Update(syncronious
brings) and then deciding you don't need to update that record.   If you
have an index that could possibly be used,  SQL will find it.    

Here's a tip,   write an SQLRPG program to do the update,   compile it
against the real file,  then do a PRTSQLINF (print SQL info) on the program,
The printout will tell you what access method the SQL thinks it will use and
the estimated time it would take to run.

John Carr
Need an SQL class ?  see www.400school.com

---------------------------------
I have a 4 million record file that I need to change some records in if they
meet certain criteria.   What are some things I can do to speed this up.
obviously sequential reading of the file is out of the question at over 4
hours to run.  I would prefer not to use the SETLL if possible,  because I
don't want to have to go in to the file and see what record to start with. 


thanks for any help.  


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---