Would Database Server exit program be an option for you? If so, do
WRKREGINF and look for:
QIBM_QZDA_INIT
QIBM_QZDA_NDB1
QIBM_QZDA_NDB1
QIBM_QZDA_ROI1
QIBM_QZDA_ROI1
QIBM_QZDA_SQL1
QIBM_QZDA_SQL2
You should be able to google how these work.
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[
mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Sent: Wednesday, April 25, 2007 4:13 PM
To: RPG400-L@xxxxxxxxxxxx
Subject: SQL diags to return actual statement executed?
Got an RPG program that does a ton of dynamic SQL INSERTs and UPDATEs,
which come from our control tables and, therefore, not actually coded in
the RPG source. Because the statements were prepared, we were able to
take the variable used in the "Execute Immediate :SQLstmt" statement and
output it to our log file.
Now, we are taking a different tack to significantly improve
performance.
Instead of using all of the dynamic SQLs, our developer has written an
application to generate the SQLRPGLE source program to do away with the
dynamic prepares. Performance improvement is dramatic but, along with
this change, we apparently lost the ability to log the SQL statement
that was actually executed. The SQL statements still use variables, and
we need to see the statements with the variables converted in the log.
We do not know how to capture this.
A while ago, I was educated in the "Get Diagnostics" statement, and a
first poke at the documentation I thought would turn up something that
would return the statement that was actually executed. But I was unable
to find anything. Am I looking in the wrong spot? FWIW, this is on
v5r3.
TIA,
Dan
--
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.
midrange.com
