How to check which are the pgms using 1 perticulate file.?
I know there is many tool available for X-reference...but
need to know is there any command available in the
system...?

Answer Posted / manjunath

As of my knowledge, DSPPGMREF and FNDSTRPDM are the 2
commands which will fulfill the requirement but both the
commands have some flaws respective to the requirement.

If we use DSPPGMREF, the files which are opened, updated
and deleted through the SQL statements will not be listed.

If source is not available in the source file, then
FNDSTRPDM will not list those programs which are using the
required files.

So, to reduce the impact, we need to use both the commands.

Let me know if i am wrong

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what happens when sflsiz = sflpag? What are the advantages and disadvantages?

718


how do I declare a minor?

718


How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?

1567


how do I declare a table or array in rpg iv?

741


What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?

2521






what are the key words you must use when using a subfile?

694


what was the robotech rpg?

689


What is the purpose of record level identifier?

732


how do I preserve and clean the array?

677


do you use message subfiles? What are the necessary keywords required coding a message subfile?

694


What is the difference between copybooks and subprocedures in as400?

814


Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg

722


How to select highest score of each subject or how to select highest income of every month?

1299


When we have a file with Duplicate records and I want to read the unique record from the file. For example a file containing Emp Name as 'Ram' and there are 3 entries of it. So how to read a unique record from File?

512


what is the necessary keyword needed to scroll subfile records?

707