In this blog post, let’s learn about the error message “25220 Schema schema cannot be created with a version lower than version.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
25220 Schema schema cannot be created with a version lower than version.
Reason for the Error
The CREATE_DEFINITION_SCHEMA_VERSION CQD is set to a schema version that is lower than the local system schema version. This setting is not permitted for CREATE SCHEMA.
Solution
Allow the system to select the schema version for the new schema: CONTROL QUERY DEFAULT CREATE_DEFINITION_SCHEMA_VERSION ‘SYSTEM
