Stored procedure content
Is there a way to "retrieve source" on a Stored Procedure ? I need to find out what 2 of our Stored Procedures do - especially what programs thay call.
Of course, no documentation and no methodology for source-based creation.
Software/Hardware used:
as/400
Of course, no documentation and no methodology for source-based creation.
Software/Hardware used:
as/400
ASKED:
November 5, 2009 7:50 PM
UPDATED:
November 6, 2009 2:21 AM
Answer Wiki:
Depending on how the *SRVPGM was created, you may be able to get what you want with DEBUG.
YOu can do a DSPSRVPGM on the main SRVPGM that has the modules.
Then do a STRDBG on a program that calls one of the modules putting a break point at the point of the callp.
Call the program, when it breaks, do F22 to step into the called procedure.
If the DEBUG level is set correctly, you will be able to see the complete source.
To see all answers submitted to the Answer Wiki: View Answer History.
Two ways to go — you can get some of the info you want from logical file SYSPROCS
But you can get all of it in Navigator (real men don’t do navigator)
..Database
Schemas — open the procedure library
— Procedures
Right click on the procedure you want
SQL