In this blog post, let’s learn about the error message “1616 Similarity Check is not supported for reason.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1616 Similarity Check is not supported for reason.
Reason for the Error
When Similarity Check is enabled for views, creating or altering a view containing nested views or a VALUES constructor is not supported. For more information, see the SQL/MX Reference Manual.
When a view definition contains nested views or a VALUES constructor or both, this error is returned for the following conditions:
CREATE or ALTER VIEW statement syntax with Similarity Check enabled
CREATE VIEW statement syntax does not specify the Similarity Check option and the CQD DDL_VIEW_SIMILARITY_CHECK is set to ON.
Solution
Modify the syntax by removing references to the nested views or VALUES constructor and resubmit the statement
