Finding Programs that Use a Specific File

Change Management
Typography
  • Smaller Small Medium Big Bigger
  • Default Helvetica Segoe Georgia Times

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.

BLOG COMMENTS POWERED BY DISQUS