I received an interesting message regarding the Passing parms to a Query post that I consider worth sharing.
Before I share the message I need to explain that there are two query engines on the IBM i (AS400): the Classic Query Engine (CQE) and the SQL Query Engine Engine (SQE). What runs through each engine is shown below:
| Classic Query Engine (CQE) |
Query/400 OPNQRYF - Open Query File QQQQry API |
Standard Query Engine (SQE) |
QM - Query Manager RUNSQLSTM - Run SQL statement Interactive SQL Embedded SQL ODBC JDBC CLI Net.Data |
The SQE is constantly being improved by IBM and much, much faster than
CQE,
Djurre Postma explained.
Recently I converted a bunch of Query/400 queries to QM Queries by simply running RTVQMQRY. The old set took about 48 hours. The QM set finished in 4 hours! There is so much more available in SQE than in CQE!
I would like to thank Djurre, and the others who sent similar messages.
You can learn more about the query engines on the IBM website here »
No comments:
Post a Comment
To prevent "comment spam" all comments are moderated.
Learn about this website's comments policy here.
Some people have reported that they cannot post a comment using certain computers and browsers. If this is you feel free to use the Contact Form to send me the comment and I will post it for you, please include the title of the post so I know which one to post the comment to.