RE: DSPPGMREF question(s)

Tommy Holden
Is the file in question used as an external DS, etc (may need to look in

any copybooks that >>may be in use as well)

There is copybook with an external DS for a logical file over the table in
question. Would that trigger it? After looking at all the source again I
did find an SQL SELECT statement referencing the file in one of the
modules. If either of those triggered it for the program shouldn't it
show for the module too?

Jon Paris
Only thing I can think of is that at one time one of the modules did use

the file, it was >>subsequently removed and the PGM object was updated
rather than being recreated. I >>believe that can cause this scenario.

The configuration of our source control software is such that *PGMs are
always created with CRTPGM. I even compiled the modules (CRTSQLRPGI) and
the program (CRTPGM) in a temp library to verify the DSPPGMREF results.
They came out the same.


An additional related question: On the external DS front - Would an
external DS defined with TEMPLATE show in DSPPGMREF?