The ROUTINES view contains one row for each routine. The following
table describes the columns in the view:
Column Name | Data Type | Description |
---|---|---|
SPECIFIC_CATALOG | VARCHAR(128) | Relational database name |
SPECIFIC_SCHEMA | VARCHAR(128) | Schema name of the routine instance. |
SPECIFIC_NAME | VARCHAR(128) | Specific name of the routine. |
ROUTINE_CATALOG | VARCHAR(128) | Relational database name |
ROUTINE_SCHEMA | VARCHAR(128) | Name of the SQL schema that contains the routine. |
ROUTINE_NAME | VARCHAR(128) | Name of the routine. |
ROUTINE_TYPE | VARCHAR(15) | Type of the routine.
|
MODULE_CATALOG | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
MODULE_SCHEMA | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
MODULE_NAME | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
UDT_CATALOG | VARCHAR(128)
Nullable | Relational database name.
Contains the null value if this is not an INSTANCE METHOD. |
UDT_SCHEMA | VARCHAR(128)
Nullable | Name of the SQL schema that contains the distinct type related to this
function.
Contains the null value if this is not an INSTANCE METHOD. |
UDT_NAME | VARCHAR(128)
Nullable | Name of the distinct type name related to this function.
Contains the null value if this is not an INSTANCE METHOD. |
DATA_TYPE | VARCHAR(128)
Nullable | Type of the result of the function:
Contains the null value if this is not a scalar function. |
CHARACTER_MAXIMUM_LENGTH | INTEGER
Nullable | Maximum length of the result string of the function for binary,
character, and graphic string data types.
Contains the null value if this is not a scalar function or the parameter is not a string. |
CHARACTER_OCTET_LENGTH | INTEGER
Nullable | Number of bytes for the result string of the function for binary,
character, and graphic string data types.
Contains the null value if this is not a scalar function or the parameter is not a string. |
CHARACTER_SET_CATALOG | VARCHAR(128)
Nullable | Relational database name of the result of the function.
Contains the null value if this is not a scalar function or the result is not a string. |
CHARACTER_SET_SCHEMA | VARCHAR(128)
Nullable | The schema name of the character set of the result of the
function. Contains 'SYSIBM'.
Contains the null value if this is not a scalar function or the result is not a string. |
CHARACTER_SET_NAME | VARCHAR(128)
Nullable | The character set name of the result of the function.
Contains the null value if this is not a scalar function or the result is not a string. |
COLLATION_CATALOG | VARCHAR(128)
Nullable | Relational database name of the result of the function.
Contains the null value if this is not a scalar function or the result is not a string. |
COLLATION_SCHEMA | VARCHAR(128)
Nullable | The schema of the collation of the result of the function. SYSIBM
is returned.
Contains the null value if this is not a scalar function or the result is not a string. |
COLLATION_NAME | VARCHAR(128)
Nullable | The collation name of the result of the function. IBMBINARY is
returned.
Contains the null value if this is not a scalar function or the result is not a string. |
NUMERIC_PRECISION | INTEGER
Nullable | The precision of the result of the function.
Contains the null value if this is not a scalar function or the result is not numeric. |
NUMERIC_PRECISION_RADIX | INTEGER
Nullable | Indicates if the precision specified in column NUMERIC_PRECISION is
specified as a number of binary or decimal digits:
Contains the null value if this is not a scalar function or the result is not numeric. |
NUMERIC_SCALE | INTEGER
Nullable | Scale of numeric result of the function.
Contains the null value if this is not a scalar function or the result is not numeric. |
DATETIME_PRECISION | INTEGER
Nullable | The fractional part of a date, time, or timestamp result of the
function.
Contains the null value if this is not a scalar function or the result is not a date, time, or timestamp. |
INTERVAL_TYPE | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
INTERVAL_PRECISION | INTEGER
Nullable | Reserved. Contains the null value. |
TYPE_UDT_CATALOG | VARCHAR(128)
Nullable | The relational database name if the result of the function is a distinct
type.
Contains the null value if this is not a scalar function or the result is not a distinct type. |
TYPE_UDT_SCHEMA | VARCHAR(128)
Nullable | The name of the schema if the result of the function is a distinct
type.
Contains the null value if this is not a scalar function or the result is not a distinct type. |
TYPE_UDT_NAME | VARCHAR(128)
Nullable | The name of the distinct type if the result of the function is a distinct
type.
Contains the null value if this is not a scalar function or the result is not a distinct type. |
SCOPE_CATALOG | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
SCOPE_SCHEMA | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
SCOPE_NAME | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
MAXIMUM_CARDINALITY | INTEGER
Nullable | Reserved. Contains the null value. |
DTD_IDENTIFIER | VARCHAR(128)
Nullable | A unique internal identifier for the result of the function. |
ROUTINE_BODY | VARCHAR(8) | The type of the routine body:
|
ROUTINE_DEFINITION | DBCLOB
Nullable | If this is an SQL routine, this column contains the SQL routine
body.
Contains the null value if this is not an SQL routine or if the routine body cannot be contained in this column without truncation. |
EXTERNAL_NAME | VARCHAR(279)
Nullable | If this is an external routine, this column identifies the external
program name.
Contains the null value if this is a system-generated function or a function sourced on a built-in function. |
EXTERNAL_LANGUAGE | VARCHAR(8)
Nullable | If this is an external routine, this column identifies the external
program name.
Contains the null value if this is not an external routine. |
PARAMETER_STYLE | VARCHAR(18)
Nullable | If this is an external routine, this column identifies the parameter
style (calling convention).
Contains the null value if this is not an external routine. |
IS_DETERMINISTIC | VARCHAR(3) | This column identifies whether the routine is deterministic. That
is, whether a call to the routine with the same arguments will always return
the same result.
|
SQL_DATA_ACCESS | VARCHAR(17) | This column identifies whether a routine contains SQL and whether it
reads or modifies data.
|
IS_NULL_CALL | VARCHAR(3)
Nullable | Identifies whether the function needs to be called if an input parameter
is the null value.
Contains the null value if this is not a function. |
SQL_PATH | VARCHAR(3483)
Nullable | If this is an SQL routine, this column identifies the path.
Contains the null value if this is not an SQL routine. |
SCHEMA_LEVEL_ROUTINE | VARCHAR(3) | Reserved. Contains 'YES'. |
MAX_DYNAMIC_RESULT_SETS | SMALLINT | Identifies the maximum number of result sets returned. 0 indicates that there are no result sets. |
IS_USER_DEFINED_CAST | VARCHAR(3)
Nullable | Identifies whether the this function is a cast function created when a
distinct type was created.
Contains the null value if the routine is not a function. |
IS_IMPLICITLY_INVOCABLE | VARCHAR(3)
Nullable | Identifies whether the this function is a cast function created when a
distinct type was created and can be implicitly invoked.
Contains the null value if the routine is not a function. |
SECURITY_TYPE | VARCHAR(22)
Nullable | Reserved. Contains 'IMPLEMENTATION DEFINED' if this is
an external routine.
Contains the null value if the routine is not an external routine. |
TO_SQL_SPECIFIC_CATALOG | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
TO_SQL_SPECIFIC_SCHEMA | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
TO_SQL_SPECIFIC_NAME | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
AS_LOCATOR | VARCHAR(3)
Nullable | Indicates whether the result was specified as a locator.
Contains the null value if this is not a scalar function. |
CREATED | TIMESTAMP | Identifies the timestamp when the routine was created. |
LAST_ALTERED | TIMESTAMP | Reserved. Contains 'CREATED'. |
NEW_SAVEPOINT_LEVEL | VARCHAR(3)
Nullable | Indicates whether the routine starts a new savepoint level.
Contains the null value if this is not a function. |
IS_UDT_DEPENDENT | VARCHAR(3) | Indicates whether the routine is dependent on a UDT.
|
RESULT_CAST_FROM_DATA_TYPE | VARCHAR(128)
Nullable | Type of the parameter:
|
RESULT_CAST_AS_LOCATOR | VARCHAR(3) | Indicates whether the result is cast from a locator.
|
RESULT_CAST_CHAR_MAX_LENGTH | INTEGER
Nullable | Maximum length of the string for binary, character, and graphic string
data types.
Contains the null value if the parameter is not a string. |
RESULT_CAST_CHAR_OCTET_LENGTH | INTEGER
Nullable | Number of bytes for binary, character, and graphic string data
types.
Contains the null value if the parameter is not a string. |
RESULT_CAST_SET_CATALOG | VARCHAR(128)
Nullable | Relational database name
Contains the null value if the column is not a string. |
RESULT_CAST_SET_SCHEMA | VARCHAR(128)
Nullable | The schema name of the character set. Contains
'SYSIBM'.
Contains the null value if the column is not a string. |
RESULT_CAST_SET_NAME | VARCHAR(128)
Nullable | The character set name.
Contains the null value if the column is not a string. |
RESULT_CAST_COLLATION_CATALOG | VARCHAR(128)
Nullable | Relational database name
Contains the null value if the column is not a string. |
RESULT_CAST_COLLATION_SCHEMA | VARCHAR(128)
Nullable | The schema of the collation. SYSIBM is returned.
Contains the null value if the column is not a string. |
RESULT_CAST_COLLATION_NAME | VARCHAR(128)
Nullable | The collation name. IBMBINARY is returned.
Contains the null value if the column is not a string. |
RESULT_CAST_NUMERIC_PRECISION | INTEGER
Nullable | The precision of all numeric parameters.
Contains the null value if the parameter is not numeric. |
RESULT_CAST_NUMERIC_RADIX | INTEGER
Nullable | Indicates if the precision specified in column NUMERIC_PRECISION is
specified as a number of binary or decimal digits:
Contains the null value if the parameter is not numeric. |
RESULT_CAST_NUMERIC_SCALE | INTEGER
Nullable | Scale of numeric data.
Contains the null value if not decimal, numeric, or binary parameter. |
RESULT_CAST_DATETIME_PRECISION | INTEGER
Nullable | The fractional part of a date, time, or timestamp.
Contains the null value if the parameter is not a date, time, or timestamp. |
RESULT_CAST_INTERVAL_TYPE | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
RESULT_CAST_INTERVAL_PRECISION | INTEGER
Nullable | Reserved. Contains the null value. |
RESULT_CAST_UDT_CATALOG | VARCHAR(128)
Nullable | The relational database name if this is a distinct type.
Contains the null value if this is not a distinct type. |
RESULT_CAST_UDT_SCHEMA | VARCHAR(128)
Nullable | The name of the schema if this is a distinct type.
Contains the null value if this is not a distinct type. |
RESULT_CAST_UDT_NAME | VARCHAR(128)
Nullable | The name of the distinct type.
Contains the null value if this is not a distinct type. |
RESULT_CAST_SCOPE_CATALOG | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
RESULT_CAST_SCOPE_SCHEMA | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
RESULT_CAST_SCOPE_NAME | VARCHAR(128)
Nullable | Reserved. Contains the null value. |
RESULT_CAST_MAX_CARDINALITY | INTEGER
Nullable | Reserved. Contains the null value. |
RESULT_CAST_DTD_IDENTIFIER | VARCHAR(128)
Nullable | A unique internal identifier for the parameter. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.