Re: Road Map to move a home grown application from RPG to DB2 SQL or to any other data base platform

Regarding Birgitta's comment about native I/O using SQE - I don't believe that is the case - both SQL and RPG make requests to the underlying DB components, so far as I remember conversations I've had. I mean, if SQE were used, there would not be the issue with FIELDPROC and encryption over key fields.

On 1/17/2017 1:48 PM, Nathan Andelin wrote:
-snip-

BTW beginning with release 7.2. all data access including QUERY/400,

OPNQRYF, native I/O is executed with the SQL Query Engine.

In regards to QUERY/400 and OPNQRYF using the SQE, that's progress. I
remember the announcement.

In regards to native I/O using SQE, I'm not sure what you're referring to.

This is not what I'm sure about either - I would need to see the announcement - the one I remember is that at 7.2 all QUERY requests were using SQE.

Note that Vern's point, and my point pertain to PF and Indexes being
essentially identical. SQL Views and Materialized Query Tables obviously
don't have precise counterparts under DDS.

Just a side comment - PF and tables are the equivalents I mentioned - the same MI object type code of x1901, as I recall.

Views and indexes are implemented as LFs - I've not done the DMPOBJ to find the MI object type.

All of these are children of lower-level space objects - gotta love the object-based nature of this our favorite system!

Cheers
Vern