RE: Sql query to find whole call stack of programs

Why reinvent the wheel?
Cross-reference code tools have existed forever for IBMi: e.g. Hawkeye PATHfinder (https://hawkinfo.com/features/ , and Aldon S-Compare https://en.wikipedia.org/wiki/Aldon_Inc.
Thousands of hours of developer time were required in building those utilities.

If you are referring to programs having source in multi-member source physical files like QRPGSRC, QRPGLESRC, QCBLSRC, QCBLLESRC, you "could" override to each source member iteratively e.g OVRDBF FILE(QRPGLESRC) TOFILE(QGPL/QRPGLESRC) MBR(PROOF) and search that member with STRSQL, and DLTOVR after viewing each member.
But why invest time in building your own ad hoc tool?

-----Original Message-----
From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of tim ken

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?