SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
9-9
Table-Valued Stored Functions
See the individual entry for the function.
Table-Valued Stored Functions
Table-valued stored functions are system-defined functions that generate a result table.
Use these functions anywhere a table reference can be used in a SELECT statement
or the SELECT form of a subquery:
See the individual entry for the function.
LNNVL Function on
page 9-89
Returns TRUE if the condition is FALSE or NULL, and FALSE
when the condition is TRUE.
DECODE Function
on
page 9-55
Compares the given expression to a set of specified conditions
one by one in the specified order. Returns the value
corresponding to the matching condition.
COALESCE Function
on page 9-27
Returns the value of the first expression in the list that is not
NULL. If all the expressions in the list result in NULL, the function
returns NULL.
COMPILERCONTROL
S Function on
page 9-31
Retrieves the active control settings, such as, CQDs, CTs, CQS
from the compiler.
EXPLAIN Function
on
page 9-66
Builds a result table that describes the access plan of a DML
statement, which can then be queried by a SELECT statement.
FEATURE_VERSION_I
NFO Function on
page 9-76
Returns feature version information for all user objects with an
object feature version (OFV) higher than a given value, in a
specified set of catalogs.
QUERYCACHE
Function on page 9-134
Collects and returns the current state of the query plan cache
statistics in a single-row result table.
QUERYCACHEENTRI
ES Function on
page 9-138
Collects and returns the query plan cache statistics in a result
table with one row for each entry of the cache.
RELATEDNESS
Function on page 9-144
Returns relatedness information for a single entity.
VERSION_INFO
Function on page 9-204
Returns version information for a single entity.