FUNCTION_INFO view

The FUNCTION_INFO view contains details about function usage identifiers.

The following table describes the columns in the view. The schema is QSYS2.

Table 1. FUNCTION_INFO view
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.
1 - CLIENT
The function is a locally managed client function within IBM i Navigator.
2 - CLIENT
The function is a locally managed client function, not within IBM i Navigator.
3 - HOST
The function is a host function.
4 - CLIENT
The function is a centrally managed client function within IBM i Navigator.
5 - CLIENT
The function is a centrally managed client function, not within IBM i Navigator.
FUNCTION_TYPE FCNTYP VARCHAR(13)
Nullable
 The type of function.
PRODUCT
The function is a function product.
GROUP
The function is a function group.
ADMINISTRABLE
The function is an administrable 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.
DENIED
The default usage does not allow usage of the function.
ALLOWED
The default usage allows usage of the function.
ALLOBJ_INDICATOR ALLOBJ VARCHAR(8)
Nullable
 Indicates whether a user with *ALLOBJ special authority can use the function.
NOT USED
The user, its groups, or default must allow usage of the function.
USED
A user with *ALLOBJ special authority is always allowed to use the function.
USAGE_INFORMATION_INDICATOR USGINFO VARCHAR(3)
Nullable
 Indicates whether there is usage information defined for the function.
NO
There is no usage information defined for the function.
YES
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