Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2006
    Posts
    27

    Unanswered: how to list all store procedures

    Hi all,

    I would like to know how to list all of the procedures that reside in my databases.

    Please give me the commands.

    Thank

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    select routineschema,routinename from syscat.routines where routinetype = 'P'

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •