SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Versioning and Distribution Messages (25000
through 25399)
HP NonStop SQL/MX Messages Manual—523730-004
18-7
SQL 25205
Where schema is the name of a schema that is referenced by a DDL or utility
operation.
Where version1 is the schema version of schema.
Where version2 is the compiler version of the compiler that executes the DDL or
utility operation.
Cause. The affected DDL or utility operation references a database object in a
schema with a schema version that is higher than the compiler version of the compiler
that executes the operation. One of these is true:
•
A downrev compiler is explicitly being used to execute the operation.
•
The operation references an object in a remote uprev schema.
Effect. The operation fails.
Recovery. Depending on the cause of the failure:
•
Do not explicitly use a downrev compiler to execute the operation.
•
Execute the operation from a node where the schema is defined.
SQL 25206
Where node is the name of the node with an incompatible version system schema.
Where version1 is the system schema version of node.
Where version2 is the compiler version of the compiler that compiles the query or
executes the DDL or utility operation.
Cause. The affected query compilation, DDL, or utility operation attempted to access
system schema tables with a system schema version that is incompatible with the
version of the compiler that compiles the query and executes the operation. This can
happen if:
•
The local system schema version is later than the MXV of a node that is involved in
the affected query. Compilation of such a query requires a downrev compiler.
25205 Schema schema has schema version version1; this is
incompatible with the version of the compiler that executes
the operation. The compiler version is version2.
25206 The system schema on node node has system schema
version version1; this is incompatible with the version of
the compiler. The compiler version is version2.