Re: SQL Table Usage in programs [part 2]

<Doug>
I have a program with the BNDDIR keyword in the CTL-OPT line. That binding
directory has several service programs in it.

My program [PROGA] uses two [PROCA, PROCD] of the 5 procedures in one of
the service programs [SRVA] in the binding directory. It uses just 2 of
the 5 available.

Is there any way, whether CL command, DB2 IBM I Service, or API [or
anything else] that will tell me the individual references *PGM object
PROGA needs? Something like: PROGA references PROCA in service program
SRVA, and PROGA references PROCD in service program SRVA?

I'm looking for something similar to the "Statically bound procedures"
section of a compile printout.

Any ideas?
</Doug>

... life could be very easy, if one is following very easy guidelines:
- make your export names unique by qualifying (prefixing) the exportname by the name of the module
- don't use CRTBNDxxx, use CRTxxxMOD and CRTPGM and CRTSRVPGM instead
- use DSPMOD detail(*EXPORT) and detail(*IMPORT) to an outfile
- et voila: you have a repository for your cross reference purposes

This would solve all problems with duplicate exports in BNDDIRs too.
I like easy living and I don't use BNDDIRs, imnstead I name all needed Modules and SRVPGMs at CRTPGM/CRTSRVPGM.
I don't use UPDPGM and UPDSRVPGM.
And I prefere rebinding after changes and not to use BinderSource wherever possible.

Life could be so easy...

D*B