Looking for QIBM_QZDA_SQL2 exit program example

[jmoreno@xxxxxxxxxxxxxxxx]

Hello iSeries community -

A while back I was able to quickly put together a program to control
ODBC/JDBC access to our production machine
using the exit program QIBM_QZDA_SQL1.

However our developers are writting more and more intricate SQL statements
and sometimes I do not get the entire
SQL statement to examine the type of request that they are making to our
production database.
( Normally the QIBM_QZDA_SQL1 has a maximum of 512 bytes that I can
ispect.)

Does anyone have a sample program that shows how this QIBM_QZDA_SQL2 is
used? I am particularly
interested in looking on how the variable "SQL string" is manipulated and
if possible the corresponding
SQL commands used. (SELECT, INSERT, DROP, ALTER, ...  etc ) and the
qualified database tables
used.
In that way I can say .. Yes that SQL statement, .. Yes that Qualified
database table ... etc

Thanks for your replies



Jorge Moreno
Overseas Military Car Sales
Woodbury, New York



+ - - - - - - - - - - - - - - - - - - - - - - - -
This email, including its attachments, may contain information that is
confidential and may be protected by federal and/or state laws and
regulations, or other confidentiality privileges.  This email, including
its attachments, may contain non-public information; therefore it is
intended to be conveyed only to the designated recipient(s).  If you are
not an intended recipient, please delete this email, including its
attachments, and notify the sender.  The unauthorized use, dissemination,
distribution or reproduction of this email, including its attachments, is
prohibited and may be unlawful.
+ - - - - - - - - - - - - - - - - - - - - - - - -