FUNCTION_USAGE view

The FUNCTION_USAGE view contains function usage configuration details.

Only users with *SECADM user special authority can examine the function usage configuration details returned with this view. Users without *SECADM authority who attempt to reference this view will get SQLCODE -443.

The following table describes the columns in the view. 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