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

MXCI Commands
HP NonStop SQL/MX Reference Manual—640322-001
4-38
GET VERSION OF SCHEMA Command
GET VERSION OF SCHEMA Command
The GET VERSION OF SCHEMA command displays the schema version of the
specified schema.
schema-name
is the ANSI name of the schema for which the schema version is requested. There
is no default for the schema-nam. However, the MXCI default catalog applies.
Error Conditions for GET VERSION OF SCHEMA
An error for the GET VERSION OF SCHEMA command occurs when:
•
The catalog of the specified schema does not exist.
•
The specified schema does not exist.
•
The specified schema is not defined on the local node and the remote node(s),
where a full replica of the schema's catalog exists, cannot be accessed.
•
An invalid schema name is specified.
Examples of GET VERSION OF SCHEMA
>> GET VERSION OF SCHEMA MYCAT.MYSCH;
VERSION: 1200
>> GET VERSION OF SCHEMA YOURDB;
VERSION: 3000
GET VERSION OF SCHEMA schema-name;