ROUTINES

Information on routines (procedures and UDFs) for which the current authorization identifier has privileges.

Column name

Data type

Contents

SPECIFIC_CATALOG

CHAR(18)

Database name

SPECIFIC_SCHEMA

CHAR(31)

Name of the schema to which the
routine belongs

SPECIFIC_NAME

CHAR(31)

Specific name of the routine

ROUTINE_CATALOG

CHAR(18)

Database name

ROUTINE_SCHEMA

CHAR(31)

Name of the schema to which the
routine belongs

ROUTINE_NAME

CHAR(31)

Name of the routine.

ROUTINE_TYPE

VARCHAR(28)

PROCEDURE	if a procedure
FUNCTION	if a UDF

DATA_TYPE

VARCHAR(24)

Data type of the return value of a UDF

CHARACTER
CHARACTER VARYING
NATIONAL CHAR
NATIONAL CHAR VARYING
REAL
DOUBLE PRECISION
FLOAT
INTEGER
SMALLINT
NUMERIC
DECIMAL
DATE
TIME
TIMESTAMP

NULL value,

if a procedure

CHARACTER_
MAXIMUM_LENGTH

SMALLINT

Max. length of the return value in code
units

if data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR or
NATIONAL CHAR VARYING

NULL value in all other cases

CHARACTER_OCTET_
LENGTH

SMALLINT

Max. length of the return value in bytes

if data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR or
NATIONAL CHAR VARYING

NULL value in all other cases

CHARACTER_SET_
CATALOG

CHAR(18)

Database name

if data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR or
NATIONAL CHAR VARYING

NULL value in all other cases

CHARACTER_SET_
SCHEMA

CHAR(31)

INFORMATION_SCHEMA

if data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR or
NATIONAL CHAR VARYING

NULL value in all other cases

CHARACTER_SET_
NAME

CHAR(18)

EBCDIC

if data type is CHARACTER or
CHARACTER VARYING

UTF16

if data type is NATIONAL CHAR or
NATIONAL CHAR VARYING

NULL value in all other cases

COLLATION_CATALOG

CHAR(18)

Database name

if data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR or
NATIONAL CHAR VARYING

NULL value in all other cases

COLLATION_SCHEMA

CHAR(31)

INFORMATION_SCHEMA

if data type is CHARACTER,
CHARACTER VARYING,
NATIONAL CHAR or
NATIONAL CHAR VARYING

NULL value in all other cases

COLLATION_NAME

CHAR(18)

EBCDIC_BINARY,

if data type is CHARACTER or
CHARACTER VARYING

UTF16_BINARY,

if data type is NATIONAL CHAR or
NATIONAL CHAR VARYING

NULL value in all other cases

NUMERIC_PRECISION

SMALLINT

Total number of significant digits

for numeric data types

NULL value in all other cases

NUMERIC_PRECISION_
RADIX

SMALLINT

Radix

for numeric data types

NULL value in all other cases

NUMERIC_SCALE

SMALLINT

Number of digits right of the decimal
point

for exact numeric data types

NULL value in all other cases

DATETIME_PRECISION

SMALLINT

Number of digits right of the decimal
point

for the data types TIME and
TIMESTAMP

NULL value in all other cases

ROUTINE_BODY

VARCHAR(8)

SQL	Programming language in which the routine was written

ROUTINE_DEFINITION

VARCHAR(32000)

Text of the routine

if the current authorization identifier
owns the schema

NULL value in all other cases

EXTERNAL_NAME

CHAR(31)

NULL value, irrelevant for SESAM/SQL

EXTERNAL_LANGUAGE

VARCHAR(7)

NULL value, irrelevant for SESAM/SQL

PARAMETER_STYLE

VARCHAR(7)

NULL value, irrelevant for SESAM/SQL

IS_DETERMINISTIC

VARCHAR(3)

NO irrelevant for SESAM/SQL

SQL_DATA_ACCESS

VARCHAR(17)

CONTAINS SQL

if CONTAINS SQL was specified in
the definition of the routine

READS SQL DATA

if READS SQL DATA was specified
in the definition of the routine

MODIFIES SQL DATA

if MODIFIES SQL DATA was
specified in the definition of the
routine

IS_NULL_CALL

VARCHAR(3)

NO if a UDF

NULL value in all other cases

SQL_PATH

VARCHAR(256)

SQL path

In SESAM/SQL, the same as the
name of the schema in which the
routine is defined

SCHEMA_LEVEL_
ROUTINE

VARCHAR(3)

YES Is part of a schema

MAX_DYNAMIC_
RESULT_SETS

SMALLINT

0 irrelevant for SESAM/SQL

IS_USER_DEFINED_
CAST

VARCHAR(3)

NO if a UDF

NULL value in all other cases

IS_IMPLICITLY_
INVOCABLE

VARCHAR(3)

NULL value, irrelevant for SESAM/SQL

SECURITY_TYPE

VARCHAR(22)

NULL value, irrelevant for SESAM/SQL

AS_LOCATOR

VARCHAR(3)

NO if a UDF

NULL value in all other cases

NEW_SAVEPOINT_
LEVEL

VARCHAR(3)

NULL value, irrelevant for SESAM/SQL

IS_UDT_DEPENDENT

VARCHAR(3)

NO irrelevant for SESAM/SQL

Table 83: ROUTINES view of the INFORMATION_SCHEMA