Home > IT Answers > AS/400 > Embedded SQL to process ALL members
Gilly400
23,625 pts.
 Embedded SQL to process ALL members
AS/400, Embedded SQL, i, iSeries, Member, OVRDBF, RPG, SQL
Hi, I'm trying to get an RPG with embedded SQL to read all the members in a file. I know I used to be able to do this with an OVRDBF command with *ALL specified for the member, but this doesn't seem to work anymore. In the joblog I get a CPF4268 message which says the file has no members or is not a partition file. Where am I going wrong here, what do I need to do to be able to process all the members? Thanks in advance, Martin Gilbert.

Software/Hardware used:
ASKED: December 22, 2008  12:54 PM
UPDATED: December 22, 2008  2:15 PM
RELATED QUESTIONS
Answer Wiki:
Alias is the standard answer for all things SQL and member-- but that seems to be limited to one member per alias. Logical file can be over all members but you will probably not be in the database engine that you would prefer. Phil
Last Wiki Answer Submitted:  December 22, 2008  2:15 pm  by  philpl1jb   44,190 pts.
All Answer Wiki Contributors:  philpl1jb   44,190 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _