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

R. O. wrote:

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

Hawkeye's Pathfinder is one good tool for this.  I would hesitate
recommending a do it yourself tool unless you are very comfortable with the
environment, i.e.:
Same file in multiple libraries
Join logicals not following the typical naming scheme
OPNQRYF
FMTDTA
OVRDBF using variable names 
CPYF / CRTDUPOBJ
Cross-system dependencies like the file being a DDM target
File transfer from/to other systems including PCs
Queries including user created queries and QMQRY
DFU programs
ReXX programs
Cobol programs
Embedded SQL, especially dynamically prepared statements
PC applications like Client/Server or ODBC
Embedded CL commands in RPG programs

I'm sure I missed some, but a busy organisation may have all of these places
to look, not just RPG, CL and DDS source...

Buck Calabro
Aptis; Albany, NY
"Nothing is so firmly believed as
 that which we least know" -- Michel Montaigne
Visit the Midrange archives at http://www.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
+---