I have a specific physical file. How do I get a list of programs that is using that PF. Is there any command (or native utility) in AS400 which can fetch that list and give that in an outfile ?
The command DSPPGMREF does a pretty good job although it can take a little while to run and you have to query the output of the command to find the usages. There are also a quite a few config parameters which alter the type of data the command produces.
Basically, the command is run over all the programs and it compiles all the usages (Files, data areas, display files etc) and writes those to a file which can be queried to find the particular file in question.
DSPPGMREF PGM(LIBRARY/*ALL) OUTPUT(*OUTFILE)
OUTFILE(QTEMP/OUTFILE)