Reference Manual
   CHAPTER 15. System Tables     

SYSPROCPARM system table

Column name	Column type	Column constraint	Table constraint
proc_id	SMALLINT	NOT NULL	Primary key, foreign key references SYS.SYSPROCEDURE
parm_id	SMALLINT	NOT NULL	Primary key
parm_type	SMALLINT	NOT NULL
parm_mode_in	CHAR(1)	NOT NULL
parm_mode_out	CHAR(1)	NOT NULL
domain_id	SMALLINT	NOT NULL	Foreign key references SYS.SYSDOMAIN
width	SMALLINT	NOT NULL
scale	SMALLINT	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

parm_mode_in (Y/N)     Indicates whether this parameter supplies a value to the procedure (IN or INOUT parameters).

parm_mode_out (Y/N)     Indicates whether this parameter returns a value from the procedure (OUT or INOUT parameters).

domain_id     Identifies the data type for the parameter, by the data type number listed in the SYSDOMAIN table.

width     Contains the length of a string parameter, the precision of a numeric parameter, or the number of bytes of storage for any other data types.

scale     The number of digits after the decimal point for numeric data type parameters, and zero for all other data type.

parm_name     The name of the procedure parameter.

remarks     A comment string.

default     The default value for the parameter, held as a string.

user_type     The user type of the parameter.