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-72

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.