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 | FUNCCREATE | 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) | 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(510) | This column identifies the routine signature. |
NUMBER_OF_RESULTS | NUMRESULTS | SMALLINT | 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 | VARCHAR(2000)
Nullable | A character string supplied with the COMMENT statement.
Contains the null value if there is no long comment. |
ROUTINE_DEFINITION | ROUTINEDEF | VARCHAR(24000)
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. |
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 | EXTACTION | 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. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.