Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


PARAMETERS


The PARAMETERS system view lists the parameters of routines on which the current ident, or PUBLIC, has EXECUTE privilege.

Column name
Data type
Description
SPECIFIC_CATALOG
VARCHAR(128)
The catalog name for the specific name of the routine.
SPECIFIC_SCHEMA
VARCHAR(128)
The schema name for the specific name of the routine.
SPECIFIC_NAME
VARCHAR(128)
The specific name of the routine.
ORDINAL_POSITION
INTEGER
The ordinal position of the parameter in the routine. The first parameter in the routine is number 1.
PARAMETER_MODE
VARCHAR(128)
Indicates whether the parameter is IN, OUT or INOUT.
PARAMETER_NAME
VARCHAR(128)
The name of the parameter.
DATA_TYPE
VARCHAR(128)
The data type of the parameter.
CHARACTER
_MAXIMUM_LENGTH
INTEGER
For a character data type, this shows the maximum length in characters.
CHARACTER
_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
_LENGTH).
CHARACTER_SET
_CATALOG
VARCHAR(128)
The name of the catalog containing the character set.
CHARACTER_SET
_SCHEMA
VARCHAR(128)
The name of the schema containing the character set.
CHARACTER_SET
_NAME
VARCHAR(128)
Name of the character set.
COLLATION_CATALOG
VARCHAR(128)
The name of the catalog containing the collation.
COLLATION_SCHEMA
VARCHAR(128)
The name of the schema containing the collation.
COLLATION_NAME
VARCHAR(128)
Name of the collation.
NUMERIC_PRECISION
INTEGER
For numeric data types, this shows the total number of significant digits allowed in the column.
For all other data types it is the NULL value.
NUMERIC_PRECISION
_RADIX
INTEGER
This shows whether the NUMERIC_PRECISION is given in a binary or decimal radix. The numeric radix is always decimal in Mimer SQL, therefore the value 10 is always shown for numeric data types. For all other data types it is the NULL value.
NUMERIC_SCALE
INTEGER
This defines the total number of significant digits to the right of the decimal point. For BIGINT, INTEGER and SMALLINT, this is 0. For BINARY, BINARY VARYING, CHARACTER, CHARACTER VARYING, DATETIME, FLOAT, INTERVAL, REAL and DOUBLE PRECISION data types, it is the NULL value.
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_TYPE
VARCHAR(128)
For interval data types, this is a character string specifying the interval qualifier for the named interval data type (see Named Interval Data Types).
INTERVAL_PRECISION
INTEGER
For interval data types, this is the number of significant digits for the interval leading precision (Named Interval Data Types).



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