Re: Sql query to find whole call stack of programs

To answer Q1). the RDi product is a client tool and independent of the server it is used with. (You can even code/verify with no connection to IBM i.)

As regards Q2)., you <may> find the RDi Visualise Application Diagram tool to be helpful, but you've already had lots of advice (below) on more comprehensive approaches you could take.

Brian

On 25/06/2023 13:56, tim ken wrote:

Thanks for all these inputs here.

1) So RDi is available for 120 days free trial for just 'PUB400.COM' only
or could be used for any other IBM i server as well ?

2) Will this RDi be able to provide the list of all the called programs
and modules and service programs from the main driver program directly
and indirectly both ?


Thanks a lot..






On Sat, 24 Jun 2023 at 18:45, Vern Hamberg via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

Hi Buck

Excellent summary, as usual! I think the OP got advice like this in his
original email, I recall some confusion about his use of the term *call
stack*. This term, in computer science so far as I can see, is used for
real-time, run-time list or tree of what has been called to get where
you are at the time. At a very low level, a stack is a LIFO
(last-in-first-out) structure that things like operations are put on to
and taken off of as a process continues. There is an SQL table function,
STACK_INFO, that has been around since 7.2, at least.

Turns out, it seems, that the request was for a cross-reference thing -
what one vendor calls used-by and where-used lists. There is no SQL
service for that from IBM.

I think this group responded to the original question much as you did,
Buck, and others did - get a cross-reference tool from one of these
vendors.

Cheers
Vern

On 6/23/2023 5:29 AM, Buck Calabro wrote:

On Fri, 23 Jun 2023 at 04:40, tim ken<timk2574@xxxxxxxxx> wrote:

By the way, has anyone got a program to find out the full call stack of

the

program here as per my earlier question here ?

The general business problem of IBM i cross reference information is
complex and difficult.
In my opinion, too complex to be solved with 'a program'.
The community generally agrees that it's more effective to buy a
solution than to write one, and so there is a viable market where
multiple vendors offer their solutions for sale.
The below is not an exhaustive list.

https://remainsoftware.com/
https://freschesolutions.com/
https://www.rocketsoftware.com/
https://www.fortra.com/
https://hawkinfo.com/
http://total400.com/

Perhaps you aren't interested in buying. Well, you just might be
living in the most excellent time to be an IBM i programmer!
RDi (sold by IBM/Rational), MiWorkplace (sold at
https://www.miworkplace.com/ but note that they offer a free version
for use with PUB400.com), and Liam's VS Code for IBM i
(https://code.visualstudio.com/, then install the extension

https://marketplace.visualstudio.com/items?itemName=HalcyonTechLtd.code-for-ibmi

- all free of charge). All of these allow integration with Git/GitHub.
That means that you - yes, you! - can start writing the tool you want,
share it with the community, and everyone can help make it better!!!

PUB400 - free
tn5250 - free
VS Code for i - free
MiWorkplace - free for PUB400
GitHub - free
Midrange.com - free
Ryver (http://ibm.biz/ibmioss-chat-join) - free

Every part of the IBM i development environment is free of charge,
available to everyone, everywhere.
Good luck!

--buck

--
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.