Viewing stored procedure statements in AS/400

270 pts.
Tags:
AS/400
SQLRPGLE
STRSQL
Hi, I created many stored procedures using STRSQL. And I called those procedures using SQLRPGLE program. It worked but I need to view those statements. I don't know how to view stored procedure statements which was created using STRSQL. Can anybody help me?

Software/Hardware used:
V5R3M0

Answer Wiki

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

Discuss This Question: 2  Replies

 
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
  • TomLiotta
    Procedures are better created in a tool such as iSeries Navigator than in STRSQL. Use Navigator to view procedure details and statements. Expand your connection. Then expand Databases-> [databasename]-> Schemas-> [schemaname]. Select Procedures to list stored procs for that schema. Right-click the procedure that you want and choose 'Generate SQL...'. Leave the defaults on the window that opens, and click [Generate]. It's also possible the query the system catalog to see the proc statements, but they're all stored in a single variable-length column. -- Tom
    125,585 pointsBadges:
    report
  • LakNar
    thanks tom
    270 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