Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


ROUTINES


Records procedures and user-defined functions in the database.

Column name
Data type
Description

ROUTINE_SYSID

INTEGER

System identifier of the function or procedure.

MODULE_SYSID

INTEGER

System identifier of the module to which the routine belongs.

ROUTINE_TYPE

CHAR(20)

One of:
"PROCEDURE"
"FUNCTION".

SQL_DATA_ACCESS

CHAR(20)

One of:
"NO SQL"
"CONTAINS SQL"
"READS SQL DATA"
"MODIFIES SQL DATA".

ROUTINE_OFFSET

INTEGER

Offset for routine within module definition.
This value is zero if the routine ins not defined in a module.

ROUTINE_LENGTH

INTEGER

Length of routine definition

TOTAL_PARAMS

INTEGER

The total number of routine parameters.

RESULT_PARAMS

INTEGER

The number of result parameters.

INPUT_PARAMS

INTEGER

The number of input parameters.

OUTPUT_PARAMS

INTEGER

The number of output parameters.

ROUTINE_DEFINITION

VARCHAR(2000)

Routine definition.
If the length of the routine definition exceeds 2000 characters this value is null.

SQL_PATH

VARCHAR(2000)

The search path for the routine.

IS_DETERMINISTIC

CHAR(3)

One of:
'"NO" = The routine is not deterministic. i.e. invoking the routine with the same input values is not guaranteed to return the same result
"YES" = The routine is deterministic, i.e. when invoked with same input values it will always return the same result.

ROUTINE_BODY

CHAR(20)

One of:
"SQL" = The routine is a SQL routine
"EXTERNAL" = The routine is external

EXTERNAL_NAME

VARCHAR(128)

The name of the program that implements the routine if it is an external routine otherwise null.

EXTERNAL_LANGUAGE

CHAR(20)

The language for the routine if it is external otherwise null.

PARAMETER_STYLE

CHAR(20)

The parameter passing style for the routine if it is an external routine, otherwise null.

SCHEMA_LEVEL_ROU

CHAR(3)

One of:
"NO" = The routine is defined within a module
"YES" = The routine is defined in a module.

MX_DYN_RESULT_SETS

INTEGER

The maximal number of result sets that the routine may return.

Primary key: ROUTINE_SYSID

Secondary index: MODULE_SYSID



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