In order to use procedures, you need to understand how to:
Create procedures
Call procedures from a database application
Drop or remove procedures
Control who has permission to use procedures
This section discusses these aspects of using procedures, and also describes some of the different uses of procedures.
Two system stored procedures that are useful when working with stored procedures are sp_iqprocedure and sp_iqprocparm. The sp_iqprocedure stored procedure displays information about system and user-defined procedures in a database. The sp_iqprocparm stored procedure displays information about stored procedure parameters, including result set variables and SQLSTATE/SQLCODE error values.
