Re: Recursive DSPPGMREF

Tim,

I think you are way out of your technical depth on this project, whatever it may be. You need professional help.

On 6/30/2023 2:57 AM, tim ken wrote:

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'))

Presumably you changed the library name where the REFS table is built?
see https://github.com/SJLennon/IBM-i-RPG-Free-CLP-Code/tree/master/PGM_REFS#pgm_refs_tblsql

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?

Stored procedures are created as a C program, which have a type of *CLE. (Similar to *RPGLE for RPG programs.)

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.

Sorry, no idea what you did wrong. Ffom the readme:
"pgm_refs.sql

This is the code to create the PGM_REFS procedure. The library in which the REFS file is built needs to be changed to suit your environment."
Lines 82-83
-- <<<< Change this table library >>>>>
insert into lennonsb.refs values (

RUNSQLSTM SRCFILE(MyLIB/MYSOURCEFILE) SRCMBR(N2)

3) Once i found this object of 'PGM_REFS' was created in some other library

Which library? Did you check the spool file created by the RUNSQLSTM command.

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

Presumably you debugged it by doing DSPPGMREF on the library and file you specified, and it showed that this program existed and had some objects? (DSPPGMREF produces a listing to the screen, or a spool file, or a output file, depending on what you specify.)

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 ?

The REFS file can be used however you wish.