Home > IT Answers > SQL Server > Stored procedure content
Aceofdelts
430 pts.
Q:
Stored procedure content
Stored Procedures, AS/400 stored procedures
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
ASKED: Nov 5 2009  7:50 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
CharlieBrowne
7810 pts.
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • Bookmark and Share
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.
Last Answered: Nov 5 2009  9:56 PM GMT by CharlieBrowne   7810 pts.
  •   
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Philpl1jb   25660 pts.  |   Nov 6 2009  2:21AM GMT

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