Access a OPNQRYF file using keys

Marg

5 pts.

Tags:

CHAIN

KEYFLD

OPNQRYF

READE

RPG

RPG/400

Is it possible to access a file created by opnqryf in an RPG/400 program using keys? I have defined the KEYFLD parameter but the RPG doesn't find the records when using READE or CHAIN.

Asked: May 14, 2009 3:37 PM Last updated: August 23, 2013 1:49 PM

Answer Wiki

Last updated: August 23, 2013 1:49 PM GMT

Ben Rubenstein11,255 pts.
History
Contributors
- Ordered by most recent
- Ben Rubenstein11,255 pts.
- WilsonAlano2,710 pts.

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

Hi,

Have you used OVRDBF SAHRE(*YES) on your file? OPNQRYF won’t work without it.
If you are using OvrDbf, are you using KEYFLD keyword on OPNQRYF?

Regards,

Wilson

I forgot the SEQONLY(*NO) parameter. It must be present too.

Wilson

//////////////////////////
And the RPG program must be compiled with the file with a similar key and using Keyed Access.

Phil

Discuss This Question: 1 Reply

WoodEngineer May 18, 2009 3:52 PM GMT

CPYFRMQRYF might do what you want. Its a bit like CPYF but uses everything you have coded into your OPNQRYF command. This is an efficient way to handle data if multiple programs need to work with the same OPNQRYF data. It prevents the overhead of multiple OPNQRYF's which select, sequence, group, key the same data. All the same rules apply, just as if you were reading the results into an RPG or COBOL program.

7,900 pointsBadges:

report