Re: Sql query to find whole call stack of programs

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.