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 |
How I can reread the physical file in CL program once the end of file reached in same CL program.
how to find whether a date format is valid or not in RPG400 not in RPGILE.Can you please write the coding for this sir,i'm new to AS400.Please help.
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?
How do I read records from Subfile? what is the purpose of READC explain with example?
What is the compilation option that has to he specified while compiling an RPC program which uses a file having date data type field?
how to retrieve RRN value in RPGLE program
1.How can you search an entire source file for a particular field name? 2.How can you find the differences between two versions of the source for the same program? 3.What is a hidden field as it relates to a sub file? 4.How do you display a sub file that has no records in the sub file?
1.Where we declare Variables in RPG/400,RPGIV,RPGILE.? 2.When do we use D-spec and I-spec in real time ?.what is difference between them?
What is use of IMPORT and EXPORT in RPGLE ? What is activation Group ? What is Service Program ???? How to call another program in RPGLE ?
wat is the difference between dataarea and data queue?
5 Answers Airtel, Four soft, Shahi Exports,
How to declare the pull button in AS/400..
1..Write an sql query to find the employee name who is having 2 phone numebr? 2.Write an sql query to the the second highest salary of the employee?