Cataloging Stored Procedures
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.
Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.
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.