Sybase Adaptive Server Anywhere - SYSPROCPARM System Table

SYSPROCPARM system table
1026
SYSPROCPARM system table
Column name Column type
Column
constraint
Table constraint
proc_id UNSIGNED INT NOT NULL Primary key, foreign
key references
SYSPROCEDURE
parm_id UNSIGNED INT NOT NULL Primary key
parm_type UNSIGNED INT NOT NULL
parm_mode_in CHAR(1) NOT NULL
parm_mode_out CHAR(1) NOT NULL
domain_id UNSIGNED INT NOT NULL Foreign key
references
SYSDOMAIN
width UNSIGNED INT NOT NULL
scale UNSIGNED INT NOT NULL
parm_name CHAR(128) NOT NULL
remarks LONG
VARCHAR
"default" LONG
VARCHAR
user_type INTEGER
Each parameter to a procedure in the database is described by one row in
SYSPROCEDURE.
proc_id Uniquely identifies the procedure to which this parameter
belongs.
parm_id Each procedure starts numbering parameters at 1. The order of
parameter numbers corresponds to the order in which they were defined.
parm_type The type of parameter will be one of the following:
♦ Normal parameter (variable)
♦ Result variable - used with a procedure that return result sets
♦ SQLSTATE error value
♦ SQLCODE error value