Re: Recursive DSPPGMREF

Tim, are you a developer? Some other kind of computer professional? If
not, do you have a developer on staff who know SQL?

This code is all SQL and I think most developers could easily use it.

But I'll give you a few pointers:
1. Did you look at the readme on GitHub? You build the output table
first by running the SQL DDL.
2. You build the stored procedure by running it in SQL.
3. The test SQL gives several examples of how to run it.
4. You can run SQL on the IBM i in several ways.
a. Paste the SQL code into the Run SQL Scripts client in iACS.
b. Put the code into a source member on the IBM i and run it with the
RUNSQLSTM command.
c. The STRSQL statement gives you a green screen where you can enter
SQL statements.
d. There are probably other ways.

If you can't figure this out, then you probably need to hire a developer.

On 6/29/2023 8:00 AM, tim ken wrote:

Hi,

This seems very good but could you please also mention the steps how to

run

below ( though something is there in readme file) :-

1) pgm.refs_Tbl.sql
2)pgm_refs.sql
3)pgm_refs_test.sql

are all these sqlrpgle programs or stored procedures , it would be nice

if

you could please elaborate in more details it's attribute type so
accordingly it could be tried to execute based on it's object type and

the

sequence like first create this with this member type (attribute type)

then

this then this and check output finally like this.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.