IBM Books

Embedded SQL Programming Guide


Registering Stored Procedures

Unlike other objects such as tables, indexes, functions, and triggers, there is no table or view in the catalog for stored procedures. However, a special table, DB2CLI.PROCEDURES (a pseudo-catalog table), has been defined by DB2 that lists and describes available stored procedures, along with the associated parameters of those stored procedures. It is recommended that administrators insert entries into this table for all stored procedures in the database. This table, and the steps for creating this table are described in the appendix of the CLI Guide and Reference.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]