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-205
VERSION_INFO Function
Table 9-8 shows the VERSION output column values for the E_TYPE and E_VALUE
parameters.
Table 9-8. Values for the E_TYPE and E_VALUE Parameters
Value for the E_TYPE and
E_VALUE Parameters Description
SYSTEM_SCHEMA The specified node.
SCHEMA All nodes where the catalog of the schema is visible. By
default, this includes the local node.
TABLE All nodes where partitions of that table reside, and the local
node.
TABLE_ALL All nodes where partitions of that table reside.
All nodes where partitions of indexes on that table reside.
All nodes where partitions of an associated trigger temp
table reside, and the local node.
INDEX All nodes where partitions of that index reside and the local
node.
INDEX_TABLE The union of TABLE for the base table of the index and
INDEX for the index itself.
VIEW All nodes where replicas for that view reside and the local
node.
PROCEDURE All nodes where replicas for that procedure reside and the
local node.
MPALIAS The node of the target SQL/MP partition and the local node.
CONSTRAINT, MODULE,
and TRIGGER
The local node.
Table 9-9. VERSION Output Column Values E_TYPE and E_VALUE
Parameters (page 1 of 2)
E_TYPE E_VALUE VERSION
SYSTEM_SCHEMA Expand node name. Use local
node if spaces.
System schema version for
actual node
SCHEMA ANSI name of schema or
database object
Schema version
TABLE
TABLE_ALL
ANSI name of table OFV of table
INDEX
INDEX_TABLE
ANSI name of index OFV of index
VIEW ANSI name of view OFV of view