IBM i & SQL Tips #010 – Locating Programs in the Call Stack with STACK_INFO

Last Updated on 2 November 2025 by Roberto De Pedrini Hello everyone, I’d like to highlight another excellent contribution by Massimo Duca , part of his ongoing IBM i & SQL Tips series. In this article, Massimo demonstrates how to use the SQL table function QSYS2.STACK_INFO to inspect and identify the programs present in the call stack of an IBM i job. 🔗 IBM i & SQL Tips #010 – Locate programs in the call stack – Massimo Duca 🧠 What STACK_INFO Does The QSYS2.STACK_INFO table function returns detailed information about the levels in the job’s call stack — in other words, the sequence of programs and procedures currently active in a given job. …