SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—544517-008
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.
QUERYCACHE
Function on page 9-112
Collects and returns the current state of the query plan cache
statistics in a single-row result table.
QUERYCACHEENTRI
ES Function on
page 9-116
Collects and returns the query plan cache statistics in a result
table with one row for each entry of the cache.