Removes a specific application context, or all application contexts. rm_appcontext is a function provided by the Application Context Facility (ACF).
rm_appcontext (“context_name”, “attribute_name”)
is a row specifying an application context name. It is saved as datatype char(30).
is a row specifying an application context attribute name. It is saved as datatype char(30).
Removes an application context by specifying some or all attributes:
select rm_appcontext("CONTEXT1", "*")
---------- 0
select rm_appcontext("*", "*")
--------- 0
select rm_appcontext("NON_EXISTING_CTX","ATTR")
--------- -1
Shows the result when a user without appropriate permissions attempts to remove an application context:
select rm_appcontext("CONTEXT1","ATTR2")
----------
-1
This function always returns 0 for success.
All the arguments for this function are required.
ANSI SQL – Compliance level: Transact-SQL extension.
Permissions depend on the user profile and the application profile, which are stored by ACF.
For more information on the Application Context Facility see “Row-level access control” in Chapter 11, “Managing User Permissions” of the System Administration Guide.
Functions get_appcontext, list_appcontext, set_appcontext
