Re: ODP / SQL Question.

[jpcarr@xxxxxxxxxxxx]

   >>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: david@midrange.com
+---