Under Procedures, the Catalog Manager displays all the database procedures that were created in the database. You can use SQL Studio to display the definitions of these database procedures, and delete the database procedures.
You need to have the required user authorizations.
For an
explanation of user authorizations and properties, see the Database Users
section in the Database System Concepts documentation.
· To display a database procedure, choose Catalog Manager ® Open Object Definition.
· To delete a database procedure, select it and choose Catalog Manager ® Drop Object.
Information on
the syntax of CREATE DBPROC statements is available in the SQL
Reference Manual under CREATE DBPROC[EDURE]
Statement (create_dbproc_statement).