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
what happens when sflsiz = sflpag? What are the advantages and disadvantages?
how do I declare a minor?
How to define data area in RPG program? In which scenario multi occurrence DS is use in AS400?
how do I declare a table or array in rpg iv?
What is the diff bw PF/LF Name and their Record format name? what is restriction in record format then file name?
what are the key words you must use when using a subfile?
what was the robotech rpg?
What is the purpose of record level identifier?
how do I preserve and clean the array?
do you use message subfiles? What are the necessary keywords required coding a message subfile?
What is the difference between copybooks and subprocedures in as400?
Program to read marks of 10 students for 4 subjects and compute and display total marks and status of each student in rpg
How to select highest score of each subject or how to select highest income of every month?
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?
what is the necessary keyword needed to scroll subfile records?