Re: Physical Files

On 4/25/2013 1:48 PM, John Mathew wrote:

and also how do I check if the physical file is used in any other programs.

This is a simple question with a very complicated answer.

CRTPF TESTLIB/FILE1
CRTPF PRODLIB/FILE1


PGM
...
DLTF TESTLIB/BACKUP
CPYF FILE1 TESTLIB/BACKUP CRTFILE(*YES)
...
ENDPGM


Is FILE1 used by this CL program?
If you are interested in FILE1, should you be interested in BACKUP?
What library is FILE1 being copied from in this CL program?


H
FBACKUP IPE ...

PGM
OVRDBF BACKUP FILE1
CALL RPGPGM
ENDPGM

Is FILE1 used in the RPG program?
Is FILE1 used in the CL program?


CRTLF FILELF (based on FILE1)

H
FFILELF UF A ...

Is FILE1 used in this RPG program?

DSPPGMREF will tell you only some of the information you need to
understand about file usage. Many midrange shops have a cross reference
tool like Hawkeye or TOTAL which will find these references in a way
that a simple DSPPGMREF or a scan with PDM can't. Ask your system admin
if such a tool is installed on your machine. It might save you a lot of
work.
--buck