Re: Sql query to find whole call stack of programs

Hi Eric

I think the OP wants to know the live job call history - option 11 on DSPJOB - this might also show IBM programs in the job.

The cross-reference tools are great for just what you describe - we use Abstract, and I've been able to get very helpful call stream diagrams, very useful for learning an entire process.

Cheers
Vern

On 6/17/2023 1:28 PM, Lehti, Eric wrote:

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?