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
1200Nullable ![]() |
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.
![]() |
| 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
1200Nullable ![]() |
Contains the label for a routine.
Contains the null value if a label does not exist.![]() |