HP NonStop SQL/MX, Messages Manual

Page: 629 / 752

Versioning and Distribution Messages (25000
through 25399)
HP NonStop SQL/MX Messages Manual —640324-001
19 -15
Cause. A CREATE SCHEMA command created a schema with a value that is not a
valid schema version.
Effect. The operation fails.
Recovery. Use a valid schema version value for the
CREATE_DEFINITION_SCHEMA_VERSION CQD. For SQL/MX R3.0, these values
are valid: 1200 and 3000. Or, allow the system to select the schema version:
CONTROL QUERY DEFAULT CREATE_DEFINITION_SCHEMA_VERSION
'SYSTEM'.
SQL 25250
Where
schema
is the name of a schema that is affected by the DOWNGRADE
operation.
Where
object
is the three-part ANSI name of a database object in
schema
.
Where
object_type
is the type of
object
. The following object types might appear
in the error message:
table
,
index
,
constraint
,
trigger
, and
view
. The object
type
table
includes internally generated objects associated with a base table.
Where
OFV
is the object feature version of
object
.
Cause. A DOWNGRADE operation affects a schema containing one or more objects
that use features that are not supported in the target version.
Effect. The DOWNGRADE operation fails.
Recovery. Use the FEATURE_VERSION_INFO built-in function to obtain the objects
names. Drop the affected objects or alter them so that they no longer have features
that are not supported in the target version.
SQL 25251
Where
operation
is the actual operation: UPGRADE or DOWNGRADE.
Where
node
is the Expand node name of an involved node.
Where
version
is the oldest supported schema version of the
node
.
Cause. The target version of an UPGRADE or DOWNGRADE operation is lower than
the oldest supported schema version of one or more nodes where an involved schema
is visible.
Effect. The operation fails.
25250 Schema schema cannot be downgraded; object_type object
has object feature version OFV .
25251 The operation operation involves node node which does
not support schema versions lower than version .