SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

MXCI Commands
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
4-40
GET VERSION OF Object Command
GET VERSION OF Object Command
The GET VERSION OF Object command displays the object schema version (OSV)
and the object feature version (OFV) of the specified database object.
object-type
is the type of object for which version information is requested. The following are
the object types:
•
TABLE
•
INDEX
•
VIEW
•
CONSTRAINT
•
TRIGGER
•
STORED PROCEDURE
•
MPALIAS
There is no default object type.
object-name
is the ANSI name of the object, of the specified type, for which the version
information is requested. There is no default for object-name. However, MXCI
default catalog and schema apply.
Error Conditions for GET VERSION OF Object
An error for the GET VERSION OF Object command occurs when:
•
The object of the specified catalog does not exist.
•
The schema of the specified object schema does not exist.
•
The specified object is not defined on the local node and the remote node(s),
where a full reference of the object's catalog exists, cannot be accessed.
•
An invalid object name is specified.
Example of GET VERSION OF Object
>> GET VERSION OF TABLE PROD.ORDERDB.ORDER_DETAIL;
OBJECT SCHEMA VERSION: 3000
OBJECT FEATURE VERSION: 1200
GET VERSION OF object-type object-name;