AS/400 stored procedures
Home > IT Answers > SQL Server > AS/400 stored procedures
Aceofdelts
410 pts.
0
Q:
AS/400 stored procedures
Stored Procedures, AS/400, SQLRPG
Is there a way to list the existing stored procedures on our box ? Those that wrote them are gone and documentation is sketchy. We found some by using any SQLRPG source as a clue but none of these were "create" routines (some were actual procedures). Seems like there ought to be an easier way.

Software/Hardware used:
AS/400
ASKED: Aug 26 2009  7:13 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Philpl1jb
24610 pts.
0
A:
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
  • AddThis Social Bookmark Button
Here
http://www.itjungle.com/mgo/mgo082003-story02.html

SELECT SPECIFIC_NAME, SPECIFIC_SCHEMA,
ROUTINE_NAME, ROUTINE_SCHEMA, EXTERNAL_NAME
FROM SYSROUTINES
WHERE ROUTINE_TYPE='PROCEDURE'
Last Answered: Aug 26 2009  8:12 PM GMT by Philpl1jb   24610 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



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

Aceofdelts   410 pts.  |   Aug 26 2009  9:47PM GMT

Fabulous !!!
Thanks. That’s just what I need.

 
0