• Subject: Re: ODP / SQL Question.
  • From: "R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>
  • Date: Mon, 29 Jan 2001 18:42:10 -0500

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

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].