Re: Recursive DSPPGMREF

Hi,

I just changed the long name 'PGM_REFS_TBL.SQL' to N1 with 'TXT' type
member and PGM_REFS.SQL to 'N2' with 'TXT' type member just for my own
convenience and to test this tool.

1) I was able to create 'REFS' file object using 1st PGM_REFS_TBL.SQL (
copied source in txt type member and then ran RUNSQLSTM Command for that
member with type as 'TXT'))

RUNSQLSTM SRCFILE(MYLIB/MYSOURCEFILE) SRCMBR(N1)

2) I was able to create an object of 'PGM_REFS' *PGM type object and it's
attribute is showing as 'CLE' , what is it's full form please?

But it was not created in my library, it was created in some other library
not sure why ? whereas 'i changed the library into the source of
'PGM_REFS.SQL' ( at 'insert into mylib.refs values (' statement) to the
same library where this 'REFS' file was created. and my library was also on
the top of the library list as well.

RUNSQLSTM SRCFILE(MyLIB/MYSOURCEFILE) SRCMBR(N2)

3) Once i found this object of 'PGM_REFS' was created in some other library
, i tried to call it using strsql session like this command "CALL 'that
libname'.PGM_REFS and then checked the file REFS then found it was still
blank no records found in it.

4) If i need to know a reference program for a specific program till
unlimited depth how can i use this program , i mean do i need to call it by
passing any parameters in int lib. name source file name and that program
name?
or

simply I could query this file 'REFS' file for a specific program name ?

Could someone please clarify the above points ?


Thanks much...



On Fri, 30 Jun 2023 at 11:05, tim ken <timk2574@xxxxxxxxx> wrote:

thanks, but what would be the type of stored procedure here and how to
compile it? once refs table( file ) is created using runsqlstm.


thanks

On Fri, 30 Jun 2023 at 00:05, Sam_L <lennon_s_j@xxxxxxxxxxx> wrote:

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.