SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—640322-001
9-65
Example of FEATURE_VERSION_INFO
Example of FEATURE_VERSION_INFO
select object_name, feature_version
from table (feature_version_info ('CATALOG', 'CATX', 1200));
OBJECT_NAME FEATURE_VERSION
---------------------------------------- ---------------
CATX."schema x"."table with large key" 3000
CATX.SCHEMAY."table with bignum column" 3000
...
Note. Possible values for the E_TYPE input parameter are:
•
CATALOG – The E_VALUE parameter specifies the external format ANSI name of a
catalog. Output rows are for objects in that catalog only.
•
CATALOG_CASCADE – The E_VALUE parameter specifies the external format ANSI
name of a catalog. Output rows are for objects in that catalog and catalogs that are related
to it.