>>We have a purchased piece of software, that works pretty good, but there is one program that seems to suck up our resources. So I looked at it, and it happens to be a RPGSQL function, and it does a lot of interactive indexing. So my questions is this. Can I created a logical file similar to this SQL, and index it the same. So when this sql is activated it would be smart enough to use an already created index instead of creating one from scratch on the fly? And if so, is there anything special I need to do to attach the logical to the job? Thanks, tim>> Tim Try this, STRDBG (you don't have to put in a program name or anything). Call the program. Look at your job log. Read the messages very carefully. It will actually tell you (in the second level text for one of the messages) what logical files would help it, and what the key should be. If this is a batch job, put a CL wrapper around it to STRDBG for the job before the program is called. Look at the job log (LOGLVL (*SECLVL). Also, run this command PRTSQLINF prompt it and fill out the parameters and look as the spool file. John Carr +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.