Yes,you can get it from SYSCAT.PROCEDURES.

Select <desired columns> from SYSCAT.PROCEDURES

Regards
Birendra

-----Original Message-----
From: Juan Norton Alea
[mailto:db2udbdba-ezmlmshield-x2645171.[Email address protected]
Sent: Thursday, July 28, 2005 8:01 PM
To: LazyDBA Discussion
Subject: list stored procedures

Hello

Is there a way for list the stored procedures by command?

thanks
Juan


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------------------------------
This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message.

DB2 & UDB email list listserv db2-l LazyDBA home page