Re: DDS define files on SQL statements

Code 1109:

Begining with V5R2, IBM introduced the new "SQL Query Engine" (SQE), and the original engine was called the "Classic Query Engine" or CQE.

And with each subsequent release, V5R3, V5R4, etc., more and more queries were automatically processed by the new SQE.

This really has very little to do with whether or not you use DDS or DDL to define your tables, views, and indexes, or PFs and LFs.

By the time of V7R1 and beyond, pretty much all queries use the SQE, and only very old stuff like "OPNQRYF" and multi-format LFs still require using the CQE.

So, there is no need to force use of RPG's "native I/O" with PFs and LFs, and you can easily write using embedded SQL over PFs and LFs, just as well as with SQL DDL defined tables and views.

All the best,

Mark S. Waterbury





On Friday, September 2, 2022 at 12:44:22 PM EDT, Code 1109 via RPG400-L <rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:





Hello all, can someone confirm what I've been told: "DDS defined tables default to the old iseries SQL engine and are less efficient using SQL" which in context I'm told to use native I/O RPG to code instead of embedded SQL if I am to use DDS files.
thank you!