Stored Procedure

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Amit Mathur
    New Member
    • Sep 2007
    • 1

    Stored Procedure

    How to retrieve/list the user defined stored procedures ?
  • raimee
    New Member
    • Sep 2007
    • 3

    #2
    Hi Amit,

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

    ex.

    db2 "select * from SYSCAT.PROCEDUR ES where PROCSCHEMA='xxx xx'"

    Comment

    Working...