Embedded SQL to process ALL members

23730 pts.
Tags:
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following