Returns the value of the attribute in a specified context.
get_appcontext ("context_name", "attribute_name")
context_name – a row specifying an application context name, saved as datatype char(30).
attribute_name – a row specifying an application context attribute name, saved as datatype char(30).
Example 1 Shows VALUE1 returned for ATTR1:
select get_appcontext ("CONTEXT1", "ATTR1")
----------- VALUE1
Example 2 ATTR1 does not exist in CONTEXT2:
select get_appcontext("CONTEXT2", "ATTR1")
------------ NULL
Example 3 Shows the result when a user without appropriate permissions attempts to get the application context:
select get_appcontext("CONTEXT1", "ATTR2")
select permisssion denied on built-in get_appcontext, database dbid
---------- -1
get_appcontext returns 0 for success and -1 for failure.
If the attribute you require does not exist in the application context, get_appcontext returns “null.”
get_appcontext saves attributes as char datatypes. If you create an access rule that compares the attribute value to other datatypes, the rule should convert the char data to the appropriate datatype.
All arguments in this function are required.
