Can OPNQRYF be used with an RPG program with embedded SQL statements for the same file?
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
SQL opens a cursor to the physical and uses full or partial access paths of logicals from the file, so I would assume that the answer would be no. Using imbedded SQL would allow you to do the same things as an OPNQRYF is capable of doing.
MORE INFORMATION ON THIS TOPIC
The Best Web Links: tips, tutorials and more.
Ask your programming questions--or help out your peers by answering them--in our live discussion forums.
Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.
Dig Deeper on RPG iSeries programming
Related Q&A from John Brandt
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.