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-199
VERSION_INFO Function
VERSION_INFO Function
VERSION_INFO is a built-in table-valued function that returns version information for a
single entity.
Table 9-7 shows the input and output parameters for VERSION_INFO.
Table 9-8
specifies the valid values for the E_TYPE and E_VALUE parameters. For all
E_TYPE values, the NODE_NAME and MXV specify Expand node name and MXV of
a node that is related to the corresponding entity.
version_info ('E_TYPE', 'E_VALUE')
Table 9-7. Input and Output Parameters for VERSION_INFO
Input/Output
Type Parameter Specification Description
Input
parameter
E_TYPE CHAR (32) NOT
NULL
The type of version information that
is requested.
Input
parameter
E_VALUE VARCHAR(776)
NOT NULL
The name of the entity for which
version information is requested.
The type of that entity is implied by
E_TYPE.
Output
column
E_TYPE CHAR (32) NOT
NULL
A copy of the actual value for the
E_TYPE input parameter.
Output
column
E_VALUE VARCHAR(776)
NOT NULL
A copy of the actual value for the
E_VALUE input parameter.
Output
column
VERSION INT NOT NULL The version of the specified entity.
Output
column
NODE_NAME CHAR(8) NOT
NULL
The Expand node name of a node
where the named entity is defined.
Output
column
MXV INT NOT NULL The SQL/MX Software Version
(MXV) of the Expand node specified
by NODE_NAME. The artificial
value 999999 indicates that the
node is unavailable and the MXV
could not be obtained. In that case,
warning 25420 (node could not
be accessed) is also returned,
once per node that is unavailable.
These warnings are returned when
the cursor to read the result set is
opened. Individual fetch operations
do not return warning 25420.