In this blog post, let’s learn about the error message “1236 The schema name specified for SQL object object-name is not valid. The schema name must be the same as the schema being created.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1236 The schema name specified for SQL object object-name is not valid. The schema name must be the same as the schema being created.
Reason for the Error
You specified a schema name for an object that is different from the name of the schema being created.
Solution
Specify a schema name for the object that matches the name of the schema being created