Contains one row for each stored procedure in the database.

The following table provides details of the SYSPROCEDURES table.

Table 1. SYSPROCEDURES system table
Column name Column data type Column size
creator VARCHAR 32
has_resultset CHARACTER 1
has_return_val CHARACTER 1
owner VARCHAR 32
proc_id INTEGER 4
proc_name VARCHAR 32
proc_type VARCHAR 32
rssid INTEGER 4
owner_domainid INTEGER 8
creator_domainid INTEGER 8