Question

  Asked: Nov 13 2006   6:55 AM GMT
  Asked by: ATHMAU


Cataloging Stored Procedures


AS/400, Application development, RPGLE, Data mining/analysis

Need to know if anyone has a package or process to do the actual storing of information around a Stored Procedure? My area is being tasked with becoming the Librian for all of our stored procedures whether created with true Sequel or RGP with imbedded SQL. I am looking for a way out side of say our change management tool to track them.

As we continue to create UI screens my area will be responsible for obtaining the data for all users directly on or called off a server. I need a way to know exactly what we already have and what it constists of.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



scottcrill@premiseinc.com
has a save restore sql procedure tool.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on AS/400, Development and DataManagement.

Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

alasdair727  |   Nov 14 2006  6:37AM GMT

For a quick look at it, anything which is actually registered as a stored procedure is listed in QSYS2/SYSROUTINE, while the parameters to it are in QSYS2/SYSPARM. You should be able to get basic information about the procedures currently defined by querying these tables.