|
I'm implementing QWVRCSTK in a trigger program for the usual reason:
to find the name of the program that performed the database update
that caused the trigger to run.
I can understand why IBM includes CSTK0200 in a generic call stack
traverser; any given call stack may indeed have Java or PASE as the
originator. But for the purposes of finding the program that fired a
trigger, I don't see how Java or PASE could be in there.
A quick test of a Java class running on the i shows me that before
QDBUDR I get:
QSQRUN3 SQL_Update
QSQROUTX QSQROUTX
QZDASRV EXECUTE
QZDASRV QZDASQL
QZDASRV SQL_ECALL
QZDASRV SQL_EXTPGM
QZDASRV SQL_CODE
QZDASRV QZDACMDP
QZDASOINIT main
It appears to me that if I use CSTK0200, the only format returned
will be STKE0100 - for the purposes of finding the code that fired
the trigger. Empirical evidence is nice, but formal documentation
would be nicer.
My big 'problem' was that I was unable to get a Java stack frame to
test with :-)
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.