SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-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-31
Retrieves the active control settings, such as, CQDs, CTs, CQS
from the compiler.
EXPLAIN Function
on
page 9-61
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-71
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-129
Collects and returns the current state of the query plan cache
statistics in a single-row result table.
QUERYCACHEENTRI
ES Function on
page 9-133
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-139
Returns relatedness information for a single entity.
VERSION_INFO
Function on page 9-199
Returns version information for a single entity.