Chapter 2: Transact-SQL Functions

rm_appcontext

Description

Removes a specific application context, or all application contexts. rm_appcontext is a function provided by the Application Context Facility (ACF).

Syntax

rm_appcontext (“context_name”, “attribute_name”)

Parameters

context_name: is a row specifying an application context name. It is saved as datatype char(30).

attribute_name: is a row specifying an application context attribute name. It is saved as datatype char(30).

Examples

Example 1

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

Example 2

Shows the result when a user without appropriate permissions attempts to remove an application context:

select rm_appcontext("CONTEXT1","ATTR2")

----------

-1

Usage

This function always returns 0 for success.
All the arguments for this function are required.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Permissions depend on the user profile and the application profile, which are stored by ACF.