SYSFUNCS
The SYSFUNCS view contains one row for each function created by the CREATE FUNCTION statement.
The following table describes the columns in the SYSFUNCS view:
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
SPECIFIC_SCHEMA | SPECSCHEMA | VARCHAR(128) | Schema name of the routine (function) instance. |
SPECIFIC_NAME | SPECNAME | VARCHAR(128) | Specific name of the routine instance. |
ROUTINE_SCHEMA | FUNCSCHEMA | VARCHAR(128) | Name of the SQL schema (schema) that contains the routine. |
ROUTINE_NAME | FUNCNAME | VARCHAR(128) | Name of the routine. |
ROUTINE_CREATED | RTNCREATE | TIMESTAMP | Identifies the timestamp when the routine was created. |
ROUTINE_DEFINER | DEFINER | VARCHAR(128) | Name of the user that defined the routine. |
ROUTINE_BODY | BODY | VARCHAR(8) | The type of the routine body:
|
EXTERNAL_NAME | EXTNAME | VARCHAR(279) Nullable
|
This column identifies the external
program name.
Contains the null value if this is a system-generated function. |
EXTERNAL_LANGUAGE | 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 | PARM_STYLE | VARCHAR(7) 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 | DETERMINE | 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 | DATAACCESS | VARCHAR(8) Nullable
|
This column identifies whether a
routine contains SQL and whether it reads or modifies data.
|
SQL_PATH | SQL_PATH | VARCHAR(3483) Nullable
|
If this is an SQL routine, this column
identifies the path. Contains the null value if this is an external routine. |
PARM_SIGNATURE | SIGNATURE | VARCHAR(2048) | This column identifies the routine signature. |
NUMBER_OF_RESULTS | NUMRESULTS | SMALLINT Nullable
|
Identifies the number of results. |
IN_PARMS | IN_PARMS | SMALLINT | Identifies the number of input parameters. 0 indicates that there are no input parameters. |
LONG_COMMENT | REMARKS | VARGRAPHIC(2000) CCSID
1200 Nullable
|
A character string supplied with
the COMMENT statement. Contains the null value if there is no long comment. |
ROUTINE_DEFINITION | ROUTINEDEF | DBCLOB(2M) CCSID 13488 Nullable
|
If this is an SQL routine, this column
contains the SQL routine body. If this is an obfuscated routine, the text starts with the WRAPPED keyword and is followed by the encoded form of the statement text. Contains the null value if this is not an SQL routine. |
FUNCTION_ORIGIN | ORIGIN | CHAR(1) | Identifies the type of function.
If this is a procedure, this column contains a blank.
|
FUNCTION_TYPE | TYPE | CHAR(1) | Identifies the form of the function.
If this is a procedure, this column contains a blank.
|
EXTERNAL_ACTION | EXT_ACTION | CHAR(1) Nullable
|
Identifies the whether the invocation
of the function has external effects.
|
IS_NULL_CALL | NULL_CALL | VARCHAR(3) Nullable
|
Identifies whether the function needs
to be called if an input parameter is the null value.
|
SCRATCH_PAD | SCRATCHPAD | INTEGER Nullable
|
Identifies whether the address of
a static memory area (scratch pad) is passed to the function.
|
FINAL_CALL | FINAL_CALL | VARCHAR(3) Nullable
|
Indicates whether a final call to
the function should be made to allow the function to clean up its
work areas (scratch pads).
|
PARALLELIZABLE | PARALLEL | VARCHAR(3) Nullable
|
Identifies whether the function can
be run in parallel.
|
DBINFO | DBINFO | VARCHAR(3) Nullable
|
Identifies whether information about
the database is passed to the function.
|
SOURCE_ SPECIFIC_SCHEMA | SRCSCHEMA | VARCHAR(128) Nullable
|
If this is sourced function and the
source is user-defined, this column contains the name of the source
schema. If this is a sourced function and the source is built-in,
this column contains 'QSYS2'. Contains the null value if this is not a sourced function. |
SOURCE_SPECIFIC_NAME | SRCNAME | VARCHAR(128) Nullable
|
If this is sourced function and the
source is user-defined, this column contains the specific name of
the source function name. Contains the null value if this is not a sourced function. |
IS_USER_DEFINED_CAST | CAST_FUNC | VARCHAR(3) Nullable
|
Identifies whether this function
is a cast function created when a distinct type was created.
|
CARDINALITY | CARD | BIGINT Nullable
|
Specifies the cardinality for a table
function. Contains the null value if the function is not a table function or if cardinality was not specified. |
FENCED | FENCED | VARCHAR(3) Nullable
|
Identifies whether the function is
fenced.
|
IASP_NUMBER | IASPNUMBER | SMALLINT | Specifies the independent auxiliary storage pool (IASP) number. |
ROUNDING_MODE | DECFLTRND | CHAR(1) Nullable
|
If this is an SQL function, identifies the DECFLOAT
rounding mode.
Contains the null value if the function is not an SQL function. |
INLINE | INLINE | VARCHAR(3) Nullable
|
Identifies whether the function can
potentially be inlined.
Contains the null value if the function is not an SQL function. |
ROUTINE_TEXT | LABEL | VARGRAPHIC(50) CCSID
1200 Nullable
|
Contains the label for a routine. Contains the null value if a label does not exist. |
SECURE | SECURE | CHAR(1) | Indicates whether the function
is considered secure for row access control and column access control.
|