SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Versioning and Distribution Messages (25000
through 25399)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
20-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 25223
Where command is the command being executed.
Where NNNN is the system schema version.
Cause. An attempt was made to execute the specified command, but the system
schema version was less than the version denoted by NNNN.
Effect. The operation fails.
Recovery. Upgrade the metadata to the appropriate schema version and resubmit the
command.
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.
25223 The command command requires the system schema version
to be at least NNNN.
25250 Schema schema cannot be downgraded; object_type object
has object feature version OFV.