RE: PF contains multiple Members

["David Dunfield" <ddunfie@xxxxxxxxxxxx>]

The only way I know of is to issue an ovrdbf command to a member, select the
records from that member, issue another ovrdbf command to the second member,
select the records, etc.

You also may be able to have 3 distinct ovrdbf commands to three separate
members, the from file would need a different unique name in each case, the
to file would be the actual file name, and the member name would be the
actual member name. The sql statement would then require a series of UNION
With clauses to retrieve the data from each member file into the set.

-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of Jonathan Oblea
Sent: Thursday, February 08, 2001 4:24 AM
To: RPG400-L@midrange.com
Subject: PF contains multiple Members





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


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---