Pages

Friday, July 26, 2013

Query Engines: CQE versus SQE

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.