REMOVE_VALIDATION_LIST_ENTRY scalar function

The REMOVE_VALIDATION_LIST_ENTRY scalar function removes an entry from the specified validation list.

This function uses the QsyRemoveValidationLstEntry()--Remove Validation List Entry API to remove the entry.

The function requires that Option 13 (System Openness Includes) of the IBM i operating system is installed.

Authorization: See Note below.

The schema is SYSTOOLS.

validation-list-library: A character string containing the name of the library that contains the validation list. Can contain the special values of *CURLIB or *LIBL.
validation-list-name: A character string containing the name of the validation list.
validation-user: A character string containing a name that exists in the specified validation list.

The result of the function is an integer. If the remove operation is successful, the function returns a value of 0. If the operation returns an error, the function returns the errno value from the API.

Note

This function is provided in the SYSTOOLS schema as an example of how a complex API can be simplified in an SQL scalar function. Similar to other Db2® for i provided tools within SYSTOOLS, the SQL source can be extracted and used as a model for building similar helper functions, or to create a customized version within a user-specified schema.

Services provided in SYSTOOLS have authorization requirements that are determined by the interfaces used to implement the service. To understand the authority requirements, extract the SQL for the service and examine the implementation.

Example

Remove an authentication entry for a specific user of an external interface. Wrap the invocation so a descriptive errno value is returned.

 
VALUES SYSTOOLS.ERRNO_INFO(SYSTOOLS.REMOVE_VALIDATION_LIST_ENTRY(
                                VALIDATION_LIST_LIBRARY => 'APPLIB', 
                                VALIDATION_LIST_NAME    => 'APPVLDL',
                                VALIDATION_USER         => 'my application user name'));