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-71
FEATURE_VERSION_INFO Function
FEATURE_VERSION_INFO Function
FEATURE_VERSION_INFO is a built-in table-valued function that 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. Information is not returned for definition
schema tables or user metadata tables.
Input and Output Parameters
Table 9-1 shows the input and output parameters for FEATURE_VERSION_INFO.
feature_version_info ('E_TYPE', 'E_VALUE', 'E_VERSION')
Table 9-1. Input and Output Parameters for FEATURE_VERSION_INFO
Input/Output
Type Parameter Specification Description
Input
parameter
E_TYPE CHAR (32) NOT
NULL
The type of version information that
is desired.
Input
parameter
E_VALUE VARCHAR(518)
NOT NULL
The name of the entity for which
version information is desired. The
type of that entity is implied by
E_TYPE.
Input
parameter
E_VERSION INT NOT NULL The target feature version.
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(518)
NOT NULL
A copy of the actual value for the
E_VALUE input parameter.
Output
column
E_VERSION INT NOT NULL A copy of the actual value for the
E_VALUE input parameter.
Output
column
OBJECT_NAM
E
VARCHAR(776)
NOT NULL
The fully qualified external format
ANSI name of a database object
with OFV higher than E_VERSION.
Output
column
OBJECT_TYPE CHAR(2) NOT
NULL
The two character object type for
the affected database object.
Output
column
FEATURE_VER
SION
INT NOT NULL The actual OFV of that database
object.