Call Level Interface Guide and Reference

Appendix G. Catalog Views for Stored Procedures

The DB2 CLI functions SQLProcedures() and SQLProcedureColumns() make use of the following two catalog tables to retrieve information about stored procedures and their attributes:

SYSCAT.PROCEDURES
SYSCAT.PROCPARMS

For more information about these tables and using the CREATE PROCEDURE command to register a stored procedure in this table, refer to SQL Reference.

[ Top of Page | Previous Page | Next Page ]