ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table constraint |
|---|---|---|---|
| proc_id | UNSIGNED INT | NOT NULL | Primary key, foreign key references 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 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 SYSPROCPARM.
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 Unused.
user_type The user type of the parameter.