RE: V5R3: OPNQRYF vs Imbedded sql

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

Rob,

As I recall, the SQE is written with object oriented design, so that the
optimized DB2 code for other platforms can be shared with our flavor of DB2.
SQE has better statistical analysis capabilities that allow the optimizer to
make more intelligent decisions about how to perform efficiently.  

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Wednesday, June 16, 2004 8:50 AM
To: midrange-l@xxxxxxxxxxxx
Subject: V5R3: OPNQRYF vs Imbedded sql


I was reading an article at
http://www.midrangeserver.com/fhg/fhg061604-story01.html
and it talked about the differences between the newer SQL Query Engine 
(SQE) and the Classic Query Engine.  One of the things it said was that 
OPNQRYF, Query/400, and the QQQQry API all will use the CQE.  Deprecated 
products?  Poorer performers?

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.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.