Contains a row for each user-defined function (scalar, table or
sourced). Does not include built-in functions.
Table 108. OBJCAT.FUNCTIONS Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| FUNCSCHEMA | CHAR(8) |
| Qualified function name. |
| FUNCNAME | VARCHAR(18) |
| |
| SPECIFICNAME | VARCHAR(18) |
| The name of the function instance (may be system-generated). |
| DEFINER | CHAR(8) |
| Authorization ID of function definer. |
| FUNCID | INTEGER |
| Internally-assigned function ID. |
| RETURN_TYPE | SMALLINT |
| Internal type code of return type of function. |
| ORIGIN | CHAR(1) |
|
B=Built-in E=User-defined, external U=User-defined, based on a source S=System-generated |
| TYPE | CHAR(1) |
|
S=Scalar function C=Column function T=Table function |
| METHOD | CHAR(1) |
|
N=Not a method Y=Method |
| EFFECT | CHAR(2) |
|
MU=mutator method OB=observer method CN=constructor method blanks=not a method |
| PARM_COUNT | SMALLINT |
| Number of function parameters. |
| PARM_SIGNATURE | VARCHAR(180) FOR BIT DATA |
| Concatenation of up to 90 parameter types, in internal format. Zero length if function takes no parameters. |
| CREATE_TIME | TIMESTAMP |
| Timestamp of function creation. Set to 0 for Version 1 functions. |
| FUNC_PATH | VARCHAR(254) | Yes | Function path at the time the function was defined. |
| TYPE_PRESERVING | CHAR(1) |
| Always blank. |
| VARIANT | CHAR(1) |
|
Y=Variant (results may differ) N=Invariant (results are consistent) Blank if ORIGIN is not E |
| SIDE_EFFECTS | CHAR(1) |
|
E=Function has external side-effects
(number of invocations is important)
N=No side-effects
Blank if ORIGIN is not E
|
| FENCED | CHAR(1) |
|
Y=Fenced N=Not fenced Blank if ORIGIN is not E |
| NULLCALL | CHAR(1) |
|
Y=Nullcall
N=No nullcall (function result is
implicitly null if operand(s) are null).
Blank if ORIGIN is not E.
|
| CAST_FUNCTION | CHAR(1) |
|
Y=This is a cast function N=This is not a cast function |
| ASSIGN_FUNCTION | CHAR(1) |
|
Y=Implicit assignment function N=Not an assignment function |
| SCRATCHPAD | CHAR(1) |
|
Y=This function has a scratch pad N=This function does not have a scratch pad Blank if ORIGIN is not E |
| FINAL_CALL | CHAR(1) |
|
Y=Final call is made to this function at run time
end-of-statement.
N=No final call is made.
Blank if ORIGIN is not E
|
| PARALLELIZABLE | CHAR(1) |
|
Y=Function can be executed in parallel N=Function cannot be executed in parallel Blank if ORIGIN is not E |
| CONTAINS_SQL | CHAR(1) |
| Indicates wheter an external function contains SQL.
N=Function does not contain SQL statements. R=Contains read-only SQL statements. M=Contains SQL statements that modify data. Blank if ORIGIN is not E |
| DBINFO | CHAR(1) |
| Indicates whether a DBINFO parameter is passed to an external
function.
Y=DBINFO is passed. N=DBINFO is not passed. Blank if ORIGIN is not E |
| RESULT_COLS | SMALLINT |
| For a table function (TYPE=T) contains the number of columns in the result table; otherwise contains 1. |
| LANGUAGE | CHAR(8) |
| Implementation language of function body. Possible values are C, JAVA or OLE. Blank if ORIGIN is not E. |
| IMPLEMENTATION | VARCHAR(254) | Yes | If ORIGIN=E, identifies the path/module/function that implements this function. If ORIGIN=U and the source function is built-in, this column contains the name and signature of the source function. Null otherwise. |
| PARM_STYLE | CHAR(8) |
| Indicates the parameter style declared in the CREATE FUNCTION
statement. Values:
DB2SQL
DB2GENRL
|
| SOURCE_SCHEMA | CHAR(8) | Yes | If ORIGIN=U and the source function is a user-defined function, contains the qualified name of the source function. If ORIGIN=U and the source function is built-in, SOURCE_SCHEMA is 'SYSIBM' and SOURCE_SPECIFIC is 'N/A for built-in'. Null if ORIGIN is not U. |
| SOURCE_SPECIFIC | VARCHAR(18) | Yes | |
| IOS_PER_INVOC | DOUBLE |
| Estimated number of I/Os per invocation; -1 if not known (0 default). |
| INSTS_PER_INVOC | DOUBLE |
| Estimated number of instructions per invocation; -1 if not known (450 default). |
| IOS_PER_ARGBYTE | DOUBLE |
| Estimated number of I/O's per input argument byte; -1 if not known (0 default). |
| INSTS_PER_ARGBYTE | DOUBLE |
| Estimated number of instructions per input argument byte; -1 if not known (0 default). |
| PERCENT_ARGBYTES | SMALLINT |
| Estimated average percent of input argument bytes that the function will actually read; -1 if not known (100 default). |
| INITIAL_IOS | DOUBLE |
| Estimated number of I/O's performed the first/last time the function is invoked; -1 if not known (0 default). |
| INITIAL_INSTS | DOUBLE |
| Estimated number of instructions executed the first/last time the function is invoked; -1 if not known (0 default). |
| CARDINALITY | INTEGER | Yes | The predicted cardinality of a table function. -1 if not known or if function is not a table function. |
| BODY | CLOB(1M) | Yes | Always null (future use). |
| REMARKS | VARCHAR(254) | Yes | User-supplied comment, or null. |