×
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.
Hi Tim,
of course - you can use the table function STACK_INFO() in library QSYS2
like this:
SELECT * FROM TABLE(QSYS2.STACK_INFO('*'))
This give you the complete call stack of the current job. Or you can
retrieve it from another job With this:
SELECT * FROM TABLE(QSYS2.STACK_INFO('123456/JOBNAME/JOBUSER'))
This is quite easy and much easier than the QWVRCSTK API.
[1]STACK_INFO [2]apple-touch-icon.png
ibm.com
The table function is available since 7.2.
I hope this helps.
Regards,
Daniel
Am 17.06.2023 um 14:24 schrieb tim ken <timk2574@xxxxxxxxx>:
Hi,
Let's say program A is calling B and Bis calling C like wise there is a
chain up to let's say 100 programs.
So in a single SQL query can i get all these program names?
Thanks.
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
References
Visible links
1.
https://www.ibm.com/docs/en/i/7.5?topic=services-stack-info-table-function
2.
https://www.ibm.com/docs/en/i/7.5?topic=services-stack-info-table-function
midrange.com
