Each row in the SYSPROCPARM system view describes one parameter to a procedure in the database. The underlying system table for this view is ISYSPROCPARM.
Column name | Column type | Description |
---|---|---|
proc_id | UNSIGNED INT | Uniquely identifies the procedure to which the parameter belongs. |
parm_id | SMALLINT | Each procedure starts numbering parameters at 1. The order of parameter numbers corresponds to the order in which they were defined. For functions, the first parameter has the name of the function and represents the return value for the function. |
parm_type | SMALLINT | The type of parameter will be one of the following:
|
parm_mode_in | CHAR(1) | Indicates whether the parameter supplies a value to the procedure (IN or INOUT parameters). |
parm_mode_out | CHAR(1) | Indicates whether the parameter returns a value from the procedure (OUT or INOUT parameters) or columns in the RESULT clause. |
domain_id | SMALLINT | Identifies the data type for the parameter, by the data type number listed in the SYSDOMAIN system view. |
width | UNSIGNED INT | Contains the length of a string parameter, the precision of a numeric parameter, or the number of bytes of storage for any other data type. |
scale | SMALLINT | For numeric data types, the number of digits after the decimal point. For all other data types, the value of this column is 1. |
user_type | SMALLINT | The user type of the parameter, if applicable. |
parm_name | CHAR(128) | The name of the procedure parameter. |
"default" | LONG VARCHAR | Default value of the parameter. Provided for informational purposes only. |
remarks | LONG VARCHAR | Always returns NULL. Provided to allow the use of previous versions of ODBC drivers with newer personal database servers. |
PRIMARY KEY (proc_id, parm_id)
FOREIGN KEY (proc_id) references SYS.ISYSPROCEDURE (proc_id)
FOREIGN KEY (domain_id) references SYS.ISYSDOMAIN (domain_id)
FOREIGN KEY (user_type) references SYS.ISYSUSERTYPE (type_id)
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |