Re: Query engine question

James,   nice chart - it really helps understand this.

jim

To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, September 22, 2006 4:26 PM
Subject: Re: Query engine question

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

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.