I think in the latest versions of DB2 they are at SYSROUTINES.
Check that one too.





"Birendra Kumar Kabi Satpathy "
<db2udbdba-ezmlmshield-x56651116.[Email address protected]
07/28/2005 10:35 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: list stored procedures







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.


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



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