Re: RE: Recursive DSPPGMREF

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

I don't really have a personal use for this. It was more of a learning 
experience. I may experiment more.

Is there a SQL Service for DSPPGMREF?  I didn't find one.

Sam

On 7/5/2023 12:25 PM, Juan Concepcion wrote:
> Good job!
>
> I've some suggestions:
> - I'd replace the native IBM i commands calls by querying SQL services.
> - I would either return a result set or create(if needed) the table on-the-fly passing the table's name as a parameter.
>
>
> Juan Concepcion
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Sam_L
> Sent: Wednesday, June 28, 2023 1:10 PM
> To: midrange-l@xxxxxxxxxxxxxxxxxx
> Subject: Recursive DSPPGMREF
>
> WARNING: EXTERNAL EMAIL. Do NOT CLICK on links or open attachments unless you are expecting it or have verified with the sender.
>
>
> For a learning experience, I've written PGM_REFS, a PL/SQL stored procedure that uses the DSPPGMREF command to display information about a program and the objects it uses, and the objects they use, to a virtually unlimited depth.
>
> You can see the code and some documentation at
>
> https://github.com/SJLennon/IBM-i-RPG-Free-CLP-Code/tree/master/PGM_REFS.