Stored procedure content

1850 pts.
Tags:
AS/400 stored procedures
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • philpl1jb
    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
    49,425 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following