Re: Sql query to find whole call stack of programs

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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?