Re: PF contains multiple Members -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

In a message dated 2/8/2001 5:10:01 AM Eastern Standard Time, JOBLE@amkor.com
writes:

Hello,

Does anyone knows how to retrieve multiple members from a PF file at the
same
time
using RPGLE and SQL ?

Ex:
If File A contain 10 members and i wanted to retrieve 3 members
at the
same time.

Thank you in advance,
Jonathan

There are many ways to do this. The obvious is by using OVRDBF with something
simple like a ? in the CL to cause it to prompt. Depending on the amount of
time you want to spend and how you want to select the records you could get a
little more complicated.

For instance, if you want to select only a specific quarter of information
you could do DSPFFD *MBRLIST *OUTFILE and have all the member information is
a file. At that point you could use RPG or CL to read the records in that
file and select only the ones you want by member name, date, or what ever.

As you can see your needs may vary and the amount of time you want to spend
on it will vary. The QD(quick and dirty) is just the OVRDBF with a ? to
select the members.

Bill