Sybase Adaptive Server Anywhere - Page 339

Chapter 8 SQL Functions
321
COALESCE ( expression , expression [ , ...] )
expression Any expression.
The following statement returns the value 34.
SELECT COALESCE( NULL, 34, 13, 0 )
♦ SQL/92 SQL/92.
♦
Sybase Compatible with Adaptive Server Enterprise.
CONNECTION_PROPERTY function [System]
Returns the value of a given connection property as a string.
CONNECTION_PROPERTY ( { integer-expression | string-expression }
... [ , integer-expression ] )
integer expression In most cases it is more convenient to supply a string
expression as the first argument. If you do supply an integer-expression, it is
the connection property ID. You can determine this using the
PROPERTY_NUMBER function.
string-expression The connection property name. Either the property ID
or the property name must be specified.
$ For a list of connection properties, see "Connection-level properties" on
page 1090.
integer-expression The connection ID of the current database
connection. The current connection is used if this argument is omitted.
The following statement returns the number of prepared statements being
maintained.
SELECT connection_property( ’PrepStmt’ )
The current connection is used if the second argument is omitted.
♦
SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
"Connection-level properties" on page 1090
"PROPERTY_NUMBER function" on page 358
Syntax
Parameters
Examples
Standards and
compatibility
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
See also