Suppose we add one field in physical file and this physical file is used by several programs.how do we know which program is using that file? What are the impact analysis.
Answers were Sorted based on User's Feedback
Answer / deepak sharma
1 By using DSPPGMREF command
2) By using Find String PDM
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / vj
DSPPGMREF give the list of object which that particular program refer. It can be file or pgm or any other object. Hence we can not find the list of programs which a particular file refer using DSPPGMREF.
We find the dependent program using x analysis, FNDSTRPDM or using Aldon option 41 on that particular file .
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / vicky
By using DSPPGMREF command, you are able to know which program is using the specific file.
| Is This Answer Correct ? | 8 Yes | 5 No |
Answer / surya siram
Hi,
Yes, by using the DSPPGMREF command on particular library, load the output to OUTFILE and by using the filters (Sequels), you can able to find the programs which are using that particular file. And also we can able to find the mode the file declared in the programs also.
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / ravi kumar
Hi Frnds,
Yes, by using the DSPPGMREF. For breif explaination see below link.
http://search400.techtarget.com/tip/Find-the-programs-that-use-a-particular-file-using-DSPPGMREF
Thanks,
Ravi
| Is This Answer Correct ? | 1 Yes | 2 No |
How to declare the dynamic(run time) array in rpgle? can you please give example
1.Suppose my file has 10 fields and I want to make the 2nd field Zeros in all records. And assume I have millions of records and I dont want to read each record and update the desired field with 0. Any other way to do this in one step operation? 2. Assume my file has 100 records and I want to see only first 10 records. Is this possible through LF? 3.I have 3 jobs A B and C. I want to submit B after successful completion of A and want to submit C after successful completion of B. Without using job scheduler or job queue, how can i do that through CL program? 4.What is difference between Bind by copy and bind by reference?
suppose one file is used by 100 user and file is locked by 100 user, what are the impact analysis?
How can we receive values from a called procedure in RPG?
Write a program to display prime numbers between 1 to 100 using RPGLE.
If there are 1000 member(PGM type) in a SRC file. How can we compile in a CL program? ( It need to be done in a loop)?
What would be the effect on the field where reverse image, underline and high intensity?
Why there is invention of RPG if we can do insert update delete in CL through SQL.Why the rise of RPG?
Have a join logical file with more than one members with different record formats. So how can we read the different members from this file and also how we can read the different record format from the join logical?
How can we receive values from a called procedure in CL?
when will come session device error?
how can we can we the data decimal error?how can we open such file in support