× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. October 2011

QWVRCSTK - CSTK0200 for 'what program fired the trigger'

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 :-)
--buck

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.