Re: Query engine question

[fu_james@xxxxxxxxxxxxxx]

Bruce,
I adapted this from an on-line presentation, hope that will help...
CQE and SQE by release
|--------------------------------+----------+----------+----------+----------|
|                                | V5R3 CQE | V5R3 SQE | V5R4 CQE | V5R4 SQE |
|--------------------------------+----------+----------+----------+----------|
| Like Predicates                | Y        |          |          | Y        |
|--------------------------------+----------+----------+----------+----------|
| Logical File References        | Y        |          | Y        |          |
|--------------------------------+----------+----------+----------+----------|
| UDTFs                          | Y        |          | Y        |          |
|--------------------------------+----------+----------+----------+----------|
| LOB Columns                    | Y        |          |          | Y        |
|--------------------------------+----------+----------+----------+----------|
| Lower, Translate or Upper      | Y        |          | Y        |          |
| scalar function                |          |          |          |          |
|--------------------------------+----------+----------+----------+----------|
| Character-length, position, or | Y        |          | Y        |          |
| substring scalar function using|          |          |          |          |
| UTF-8/16                       |          |          |          |          |
|--------------------------------+----------+----------+----------+----------|
| Alternate Sort Sequences       | Y        |          | Y        |          |
|--------------------------------+----------+----------+----------+----------|
| Derived Logical Files Over     | Y        |          | Y        |          |
| Physical (S/O)                 |          |          |          |          |
|--------------------------------+----------+----------+----------+----------|
| Non-SQL Queries (QQQQry API,   | Y        |          | Y        |          |
| Query/400, OPNQRYF)            |          |          |          |          |
|--------------------------------+----------+----------+----------+----------|
| Alwcpydta(*NO)                 | Y        |          |          | Y        |
|--------------------------------+----------+----------+----------+----------|
| Sensitive cursor               | Y        |          |          | Y        |
|--------------------------------+----------+----------+----------+----------|
| Views, Unions, SubQueries      |          | Y        |          | Y        |
|--------------------------------+----------+----------+----------+----------|
| Insert, Update, Delete         |          | Y        |          | Y        |
|--------------------------------+----------+----------+----------+----------|
| Star Schema join Queries       |          | Y        |          | Y        |
|--------------------------------+----------+----------+----------+----------|
| Derived Key and Select/Omit    | Y        |          | Y        |          |
| Logical Files on the table     |          |          |          |          |
| queried                        |          |          |          |          |
|--------------------------------+----------+----------+----------+----------|


Best Regards.

James Fu

TDL Group Corp. (Tim Hortons)
Oakville, Ontario
Direct: 905-339-5798
fu_james@xxxxxxxxxxxxxx
Web: http://www.timhortons.com