SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

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