Re: ODP / SQL Question.

The simple short answer is yes.

But, if you can put that job in debug and then check the joblog, the
messages will guide you in building the correct access path... assuming that
it is not all dynamic calls...

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"Those who would give up essential Liberty,
  to purchase a little temporary Safety,
  deserve neither Liberty nor Safety."

     - The Papers of Ben Franklin

-----Original Message-----
From: Hatzenbeler, Tim <thatzenbeler@clinitech.net>
To: 'MIDRANGE-L@midrange.com' <MIDRANGE-L@midrange.com>
Date: Monday, January 29, 2001 5:42 PM
Subject: ODP / SQL Question.


> 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
>

+---
| 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
+---