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

MXCI Commands
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
4-39
GET VERSION OF SYSTEM SCHEMA Command
GET VERSION OF SYSTEM SCHEMA
Command
The GET VERSION OF SYSTEM SCHEMA command displays the system schema
version of the specified node. If no node is specified, the system schema version of the
local node is displayed.
node
is the node name for which the system schema version information is requested.
The default is the local node.
Error Conditions for GET VERSION OF SYSTEM SCHEMA
An error for the GET VERSION OF SYSTEM SCHEMA command occurs when:
•
The specified node does not exist.
•
The specified node cannot be accessed.
•
SQL/MX is not installed on the specified node.
•
SQL/MX has not been initialized on the specified node.
•
An invalid node name is specified.
Example of GET VERSION OF SYSTEM SCHEMA
>> GET VERSION OF SYSTEM SCHEMA ON \NODEY;
VERSION: 1000
GET VERSION OF SYSTEM SCHEMA [ ON node ];