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...?
Answers were Sorted based on User's Feedback
Answer / 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 |
What is significance of a file designated as a Primary file in Rpg400 program....also what's use of secoundry file
What hapens when we use CPYF command to copy a LF? On which PF will it be dependent???
How can you delete records form a file in rpg without using "Delete" OPCODE?
How to read data from Nth member of a physical file containing some X number of members in it? "Provided member names are unknown"
what is the difference between the cpyf command crtdupobj command?
what is use of sflnxtchg and use of MDT(modify data tag).both r same r not and can we use these on dspf and subfile.
what is edit word and edit code
What is the significance of UDATE?
what is meant by record lock.how records are locked.what is the purpose of record lock.if records are locked what happens.how to find out which record is locked.
What is SFLNXTCHG keyword why it has used and where? Briefly explain with Example.
give an eg of ACQ-(ACQUIRE),BIT OFF,BIT ON,DEALLOC,DUMP,FEOD,FORCE,MHHZO,MHLZO,MHLLZO,MLHZO,REL,RESET,TESTZ,TESTB,TESTN----GIVE SMALL EXAMPLE TO THE OPCODES...TO UNDERSTAND FUNCTIONING...........
without logical file we cannot access the data in physical file.but we specify physical file in the program(ie:- Ffile IF E k disk).how can it be accessed?