Can OPNQRYF be used with an RPG program?

Can OPNQRYF be used with an RPG program with embedded SQL statements for the same file?

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.


This was first published in December 2002