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 |
1.How to read a subfile in out put mode? 2.what are the keywords used to share same file? 3.using composite key which rpg code used?
we are sending data of physical file to screen design and it is showing no record why?
HOW TO DELETE THE RECORD FROM MASTER FILE WHICH IS LINK BY ANOTHER TRASATION FILE WITH REFERTIAL INTYGRITY?
HI,1: What is the function of 'SETON LR' AND '*INLR=*ON ? 2:Can we used "seton lr" OR "*INLR = *ON" in between the program code ? 3:if yes then according to there function the code which is written acter seton lr/ *inlr should not be execute . Can any one tell me why those code get executed ?
wat is scan and check ? give me real time scenarios where we used these keywords in ur projects?
3. Given the DOS Specification below and the following information: • Indicator 50 is off • No records have been written to the subfile What will be the result if the EXFMT operation code is performed on the record format CTLR? A R SUBFL A DESCRIP 101 6 1ODSPATR(UL) A DFT(’NOT FOUND’) A R CTLR SFLCTL(SUBFL) A N50 SFLDSP A SFLDSPCTL A SFLINZ A 67 SFIJEND A SFLSIZ(13) A SFLPAG(12) A ACCOUNTNO 100 S 10 a.) Only AccountNo will display b.) SUBFL will be initialized with 13 blank records c.) An I/O exception error will occur d.) The screen will display 12 records with ‘NOT FOUND’
How to find d key field of a pf that doesn’t have source physical file?
CAN WE READ RECORDS WITHOUT USING SETLL,READ,CHAIN IN RPG?
Anyone help me for the below question:- If problem/error occur in *PSSR subroutine,how should I handel it in RPG program.
How Commitment and Roll back control is used in as400, explain with real time senario ???
which MONMSG will give higher priority in CL program? I know MONMSG are of two types. Program Level Monmsg and Command Monmsg?
How to add 2 new fields in a file? How many ways are there in as400?