From: Carlos Irigoyen To: All
How do I easily locate the programs that use a specific file?
From: Sharon Cannon To: Carlos Irigoyen
There may be other ways to do it, but here's what I do. About once a week, I run this command.
DSPPGMREF PGM(*ALLUSR/*ALL) + OUTPUT(*OUTFILE) OBJTYPE(*ALL) + OUTFILE(TESTLIBR/PGMFLXREF)
I keep the resulting cross-reference file in my testing library. When I need to know what programs use a file, I run Query/400 or SQL/400 queries against the cross-reference file, selecting for the file names I want. You can run the Display File Field Description (DSPFFD) command on the cross-reference file to find out the field names in the record.