FUNCTION_USAGE view

The FUNCTION_USAGE view contains function usage configuration details.

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: The caller must have *SECADM special authority.

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

Table 1. FUNCTION_USAGE view
Column Name	System Column Name	Data Type	Description
FUNCTION_ID	FCNID	VARCHAR(30)	The ID of the function.
USER_NAME	USER_NAME	VARCHAR(10)	The name of the user profile that has a usage setting for this function
USAGE	USAGE	VARCHAR(7)	Usage setting. ALLOWED The user profile is allowed to use the function. DENIED The user profile is not allowed to use the function.
USER_TYPE	USER_TYPE	VARCHAR(5)	Type of user profile. USER The user profile is a user. GROUP The user profile is a group.

Example

Determine what function usage has been granted or revoked.

 SELECT * FROM QSYS2.FUNCTION_USAGE ORDER BY FUNCTION_ID, USER_NAME