list_appcontext

Description

Lists all the attributes of all the contexts in the current session. list_appcontext is a built-in function provided by the Application Context Facility (ACF).

Syntax

list_appcontext (["context_name"])

Parameters

context_name

is an optional argument that names all the application context attributes in the session.

Examples

Example 1

Shows the results when a user with appropriate permissions attempts to list the application contexts:

select list_appcontext ([context_name])

Context Name: (CONTEXT1)
Attribute Name: (ATTR1) Value: (VALUE2)
Context Name: (CONTEXT2)
Attribute Name: (ATTR1) Value: (VALUE1)

Example 2

Shows the results when a user without appropriate permissions attempts to list the application contexts:

select list_appcontext()

Select permission denied on built-in list_appcontext, database DBID
--------
-1

Usage

• This function returns 0 for success.

• Since built-in functions do not return multiple result sets, the client application receives list_appcontext returns as messages.

Standards

ANSI SQL – Compliance level: Transact-SQL extension

Permissions

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

See also

For more information on the ACF, see “Row-level access control” in Chapter 11, “Managing User Permissions” of the System Administration Guide.

Functions get_appcontext, list_appcontext, rm_appcontext, set_appcontext

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF