|
Hi Jonathon, Two ways come to mind, not sure how suitable they are for what you want to do: 1. In an RPGLE program define the file as USROPN and use OPEN - OVRDBF(via QCMDEXC) - CLOSE to process the members one at a time. 2. Create a logical using the DTAMBRS parameter to base one logical file member across more than one of the physical file members. If the selected members need to be determined at run-time, this could be done in a CL wrapper, or maybe even as above using QCMDEXC? You would probably be best doing a RMVM follwed by a ADDLFM, and could supply the program with the list of members to be included. Have never done it myself, but I think it should be feasable. hth Nigel <snip> 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 <endsnip> +--- | 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.