Each row in the SYSPROCEDURE system view describes one procedure in the database. The underlying system table for this view is ISYSPROCEDURE.
| Column name | Data type | Description |
|---|---|---|
| proc_id | UNSIGNED INT | Each procedure is assigned a unique number (the procedure number). |
| creator | UNSIGNED INT | The owner of the procedure. |
| object_id | UNSIGNED BIGINT | The internal ID for the procedure, uniquely identifying it in the database. |
| proc_name | CHAR(128) | The name of the procedure. One creator cannot have two procedures with the same name. |
| proc_defn | LONG VARCHAR | The definition of the procedure. |
| remarks | LONG VARCHAR | Remarks about the procedure. This value is stored in the ISYSREMARK system table. |
| replicate | CHAR(1) | This property is for internal use only. |
| srvid | UNSIGNED INT | If the procedure is a proxy for a procedure on a remote database server, indicates the remote server. |
| source | LONG VARCHAR | The preserved source for the procedure. This value is stored in the ISYSSOURCE system table. |
| avg_num_rows | FLOAT | Information collected for use in query optimization when the procedure appears in the FROM clause. |
| avg_cost | FLOAT | Information collected for use in query optimization when the procedure appears in the FROM clause. |
| stats | LONG BINARY | Information collected for use in query optimization when the procedure appears in the FROM clause. |
PRIMARY KEY (proc_id)
FOREIGN KEY (srvid) REFERENCES SYS.ISYSSERVER (srvid)
FOREIGN KEY (object_id) REFERENCES SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL
FOREIGN KEY (creator) REFERENCES SYS.ISYSUSER (user_id)
UNIQUE INDEX (proc_name, creator)