FUNCTION_INFO view
The FUNCTION_INFO view contains details about function usage identifiers.
The values returned for the columns in the view are closely related to the values returned by the Display Function Usage (DSPFCNUSG) CL command.
Authorization: None required.
The following table describes the columns in the view. The system name is FCN_INFO. The schema is QSYS2.
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
FUNCTION_ID | FCNID | VARCHAR(30) Nullable
|
The function ID. |
FUNCTION_CATEGORY | FCNCAT | VARCHAR(10) Nullable
|
Indicates whether the function
is a client or host function.
|
FUNCTION_TYPE | FCNTYP | VARCHAR(13) Nullable
|
The type of function.
|
FUNCTION_NAME_MESSAGE_TEXT | FCNMSGTXT | VARGRAPHIC(330)
CCSID(1200) Nullable |
The first-level text for the function-name message ID. |
FUNCTION_NAME | FCNNAM | VARGRAPHIC(330)
CCSID(1200) Nullable |
The text for the function name. |
FUNCTION_DESCRIPTION_MESSAGE_
TEXT |
FCNDESCTXT | VARGRAPHIC(330)
CCSID(1200) Nullable |
The first-level text for the function-description message ID. |
FUNCTION_DESCRIPTION | FCNDESC | VARGRAPHIC(330)
CCSID(1200) Nullable |
The text for the function description. |
FUNCTION_PRODUCT_ID | FCNPRDID | VARCHAR(30) Nullable
|
The ID of the product that the function is registered for. |
FUNCTION_GROUP_ID | FCNGRPID | VARCHAR(30) Nullable
|
The ID of the function group that the function is grouped with. If the function is not grouped with a function group, this field is set to *NONE. |
DEFAULT_USAGE | DFTUG | VARCHAR(7) Nullable
|
The default usage for the function.
|
ALLOBJ_INDICATOR | ALLOBJ | VARCHAR(8) Nullable
|
Indicates whether a user with *ALLOBJ
special authority can use the function.
|
USAGE_INFORMATION_INDICATOR | USGINFO | VARCHAR(3) Nullable
|
Indicates whether there is usage
information defined for the function.
|
Example
Determine what function usage IDs exist and their default configuration.
SELECT * FROM QSYS2.FUNCTION_INFO ORDER BY FUNCTION_ID