How to check which are the pgms using 1 perticulate file.? I know there is many

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...?

Question Posted / samul

4 Answers
9957 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to check which are the pgms using 1 perticulate file.? I know there is many tool available for ..

Answer / manu

use the command FNDSTRPDM..

Is This Answer Correct ?

7 Yes

1 No

How to check which are the pgms using 1 perticulate file.? I know there is many tool available for ..

Answer / mahesh

with wrkmbrpdm select source library and source file. type
option 25 against all pgms.(use F13 to repeat to all pgms
<Press Enter> enter file name to be search . This will
displa program by program

Is This Answer Correct ?

6 Yes

1 No

How to check which are the pgms using 1 perticulate file.? I know there is many tool available for ..

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

How to check which are the pgms using 1 perticulate file.? I know there is many tool available for ..

Answer / durgesh mishra

dsppgref......command

Is This Answer Correct ?

7 Yes

6 No

Post New Answer

More RPG400 Interview Questions

Delete FileName at first statement in RPG.

1 Answers

i have 6 char field in program, but this field is using in all files i want to chage field size as 10 char , how can i do this except using *like defn...?

1 Answers IBM,

This is my Physical file 'EMPS' existing in library "TAMIL1" and its record format is 'EMPRCD" a)its source is R EMPRCD ENO 4 0 ENAME 10 EADD 10 b)The records present in EMPS are as follows ENO ENAME EADD 0001 tamil coimbatore 0002 kumar bangalore 0003 sunder bangalore 0004 arunkumar chennai 0005 pandi hyderabad 0006 santhosh hyderabad 0007 sasi salem 0008 kalai chennai 0009 suresh hyderabad 0010 vijay bangalore 0011 Arul chennai 0012 velu chennai 0013 khan bangalore 0014 praba chennai 0015 praba.p coimbatore 0016 anand ooty 0017 raja erode 0018 sankar erode 0019 vadivel namakkal 0020 anbu chennai 0021 Ajith mumabi c)now i want to select the 'ENAME' field records starting with 'S' for that i have created a RPG program its source code is PGM DCLF FILE(TAMIL1/EMPS) DCL VAR(&MYENO) TYPE(*CHAR) LEN(4) OVRDBF FILE(EMPS) SHARE(*YES) OPNQRYF FILE((TAMIL1/EMPS)) QRYSLT('ENAME *EQ %WLDCRD("S *")') READ: RCVF RCDFMT(EMPRCD) MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END)) CHGVAR VAR(&MYENO) VALUE(&ENO) SNDUSRMSG MSG(&MYENO) SNDUSRMSG MSG(&ENAME) SNDUSRMSG MSG(&EADD) GOTO READ END: CLOF OPNID(EMPS) DLTOVR FILE(EMPS) ENDPGM Is this coding correct sir,the program gets compiled,and if i call it it says query running but records are not displayed.please help me out

4 Answers Virtusa,

can we perform CHAIN operation on Subfile record format....?

4 Answers

when will come session device error?

4 Answers TCS,

Why we cannot call a service program? If I add a PEP can i call the service program?

1 Answers DELL,

Can we have a Physical file without any member ? Please let me know

12 Answers

1.Coding in cl to send an message? 2..What is turnover and use? What are the different levels?

4 Answers IBM,

what r drawbacks of OPM? Why do we go for ILE RPG?