Re: List all Programs that use a Physical/Logical File

Just a suggestion, but why not use

DSPPGMREF PGM(*ALLUSR/*ALL) OUTPUT(*OUTFILE) OUTFILE(XYZ/PGMREF)

instead of scanning all the source files? Granted that programs that are not
compiled will not be included, but in most situations I've been in, those
programs are still in development and will be taken care of anyway.

After the above statement, a simple SQL SELECT, query, QM query or program
of your choice can be used to read the file and print it.

HTH,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

From: "R. O." <otis_the_cat@hotmail.com>
> I need to change a field definition in a physical file for a project.
> Rather than go through every program on the system one-at-a-time to see if
> the program(s) use the physical file (or logical files), I would like to
> write a program that will cycle through all of QCLSRC, QRPGSRC, and
> QRPGLESRC and check the F Specs for the physical and logical file names.
> Anybody have a quick way to accomplish this?  Any info would be
appreciated.



> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---