By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,284 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

Stored Procedure

P: 1
How to retrieve/list the user defined stored procedures ?
Sep 13 '07 #1
Share this Question
Share on Google+
1 Reply


P: 3
Hi Amit,

check the system catalog tables. You should find what you're looking for there.

ex.

db2 "select * from SYSCAT.PROCEDURES where PROCSCHEMA='xxxxx'"
Sep 13 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.