Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


ROUTINES


The ROUTINES system view lists the 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.
ROUTINE_CATALOG
VARCHAR(128)
The name of the catalog containing the routine.
ROUTINE_SCHEMA
VARCHAR(128)
The name of the schema containing the routine.
ROUTINE_NAME
VARCHAR(128)
The name of the routine.
MODULE_CATALOG
VARCHAR(128)
The name of the catalog containing the module to which the routine belongs.
MODULE_SCHEMA
VARCHAR(128)
The name of the schema containing the module to which the routine belongs.
MODULE_NAME
VARCHAR(128)
The name of the module to which the routine belongs.
ROUTINE_TYPE
VARCHAR(20)
Indicates whether the routine is a function or a procedure.
DATA_TYPE
VARCHAR(30)
The data type returned by the function.
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(30)
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, see Named Interval Data Types.
EXTERNAL
_LANGUAGE
VARCHAR(20)
The language for the routine if it is an external routine, otherwise the NULL value is shown
IS_DETERMINISTIC
VARCHAR(3)
One of:
"YES" = the function was declared as DETERMINISTIC when it was created
"NO" = the function was not declared as DETERMINISTIC when it was created.
SQL_DATA_ACCESS
VARCHAR(128)
One of:
"CONTAINS SQL"
"READS SQL"
"MODIFIES SQL".
ROUTINE_BODY
CHAR(20)
One of:
"SQL" = the routine is an SQL routine
"EXTERNAL" = the routine is an external routine.
ROUTINE
_DEFINITION
VARCHAR(2000)
The text of the routine definition. If the actual definition would not fit into the maximum length of this column, the NULL value will be shown and the definition text will appear in the view EXT_SOURCE_DEFINITION.
EXTERNAL_NAME
VARCHAR(128)
The external name of the routine if it is an external routine, otherwise the NULL value is shown.
PARAMETER_STYLE
CHAR(20)
The parameter passing style of the routine if it is an external routine, otherwise the NULL value is shown.
SQL_PATH
VARCHAR(2000)
The path for the routine.
The NULL value is shown if no path is defined.
SCHEMA_LEVEL
_ROUTINE
CHAR(3)
One of:
"YES" = the routine was created on its own
"NO" = the routine was created in a module.
IS_RESULT
CHAR(3)
One of:
"YES" = the routine returns a result-set
"NO" = the routine does not return a result-set.



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