SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—640322-001
9-9
Table-Valued Stored Functions
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.
COMPILERCONTROL
S Function on
page 9-28
Retrieves the active control settings, such as, CQDs, CTs, CQS
from the compiler.
EXPLAIN Function
on
page 9-55
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-64
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-116
Collects and returns the current state of the query plan cache
statistics in a single-row result table.
QUERYCACHEENTRI
ES Function on
page 9-120
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-126
Returns relatedness information for a single entity.
VERSION_INFO
Function on page 9-177
Returns version information for a single entity.