Home |
Previous Page | Next Page System Catalog Tables >
The sysprocbody system catalog table
describes the compiled version of each procedure or function in
the database. Because the sysprocbody table
stores the text of the routine, each routine can have multiple rows.
The sysprocbody table has the following columns.
| Column |
Type |
Explanation |
| procid |
INTEGER |
Unique identifying code for the routine |
| datakey |
CHAR(1) |
Type of information in the data column:
D = User document text
E = Creation time information
L = Literal value (that is, literal number or quoted string)
P = Interpreter instruction code (p-code)
R = Return value type list
S = Routine symbol table
T = Actual routine source |
| seqno |
INTEGER |
Line number within the routine |
| data |
CHAR(256) |
Actual text of the routine |
The data column contains actual data, which
can be in one of these formats:
- Encoded return values list
- Encoded symbol table
- Literal data
- P-code for the routine
- Compiled code for the routine
- Text of the routine and its documentation
A composite index on the procid, datakey,
and seqno columns allows only unique values.
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]