Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


PARAMETERS


Records parameters of routines in the database.

Column name
Data type
Description

ROUTINE_SYSID

INTEGER

System identifier for the function or procedure.

ORDINAL_POSITION

INTEGER

The ordinal position of the parameter in the routine. The first parameter in the routine is number 1.

IS_RESULT

CHAR(3)

One of:
'NO' = This parameter is not part of the result clause for a result set procedure
'YES' = This parameter is part of the result set.

PARAMETER_MODE

CHAR(5)

One of:
"IN"
"OUT"
"INOUT".

PARAMETER_NAME

VARCHAR(128)

The name of the parameter.

DOMAIN_SYSID

INTEGER

System identifier of the domain that defines the data type of the parameter.

COLLATION_SYSID

INTEGER

System identifier of the collation associated with the parameter.

DATA_TYPE

CHAR(30)

The data type of the parameter.

INTERVAL_TYPE

CHAR(30)

For interval data types, this is a character string specifying the interval qualifier for the named interval data type, see the Mimer SQL Reference Manual.
For other data types it is the NULL value.

CHAR_MAX_LENGTH

INTEGER

For a character data type, this shows the maximum length in characters.

CHAR_OCTET_LENGTH

INTEGER

For a character data type, this shows the maximum length in octets.
For single octet character sets, this is the same as CHARACTER_MAX_LENGT.

NUMERIC_PRECISION

INTEGER

For numeric data types, this shows the total number of decimal digits allowed in the column.
For all other data types it is the NULL value. NUMERIC_PREC_RADIX indicates the units of measurement.

NUMERIC_SCALE

INTEGER

This defines the total number of significant digits to the right of the decimal point.
For INTEGER and SMALLINT, this is 0.
For CHARACTER, CHARACTER VARYING, DATETIME, FLOAT, INTERVAL, REAL and DOUBLE PRECISION data types, it is the NULL value.

NUMERIC_PREC_RADIX

INTEGER

For numeric data types, the value 10 is shown because NUMERIC_PRECISION specifies a number of decimal digits.
For all other data types it is the NULL value.
NUMERIC_PRECISION and NUMERIC_PREC_RADIX can be combined to calculate the maximum number that the column can hold.

DATETIME_PRECISION

INTEGER

For DATE, TIME, TIMESTAMP and interval data types, this column contains the number of digits of precision for the fractional seconds component.
For other data types it is the NULL value.

INTERVAL_PRECISION

INTEGER

For interval data types, this is the number of significant digits for the interval leading precision, see the Mimer SQL Reference Manual.
For other data types it is the NULL value.

Primary key: ROUTINE_SYSID, ORDINAL_POSITION, IS_RESULT



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX