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