RE: QAQQINI - Query options file and performance of SQL

Rob,

Here's a pretty detailed coverage of QAQQINI.
http://www-912.ibm.com/s_dir/slkbase.nsf/1ac66549a21402188625680b0002037e/9f
bb11f1725466578625694c007511a1?OpenDocument&Highlight=0,QAQQINI

Here's a short (but useful) document from the terraplex...
http://www-1.ibm.com/servers/enable/site/bi/teraplex/lessons.html

hth,

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



-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Thursday, September 09, 2004 11:33 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: QAQQINI - Query options file and performance of SQL


Developer here is trying to shave some time off of a SQL operation in an 
imbedded rpg program.  Bulk of the time in the joblog based on the debug 
is spent in various CPI4339 - Query options retrieved file QAQQINI in 
library QUSRSYS.  Sure calls this alot.  Spends more time reading this 
file than access path considerations, OPEN's, PREPARE's, etc.  I can't 
think of anything to do, on my end, to reduce the CPI4339 times.  I 
suppose I need to point this out to IBM as 'an area of concentration of 
effort'.

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 RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.