True enough - the 1000 record type includes the statement text, so you
can get that in your output, sorted by optimizer used - nice!
On 3/4/2014 2:56 PM, rob@xxxxxxxxx wrote:
I could sort by optimizer used.
-- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept
1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108
6928N 400E Kendallville, IN 46755 http://www.dekko.com In order to see
if a statement is optimized with CQE, it is necessary to run a
monitor, then query over the data - I did not see, at the latest IBM i
Access, an option to filter by optimizer used.