In this blog post, let’s learn about the error message “2050 attribute is not the name of any DEFAULTS table attribute.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
2050 attribute is not the name of any DEFAULTS table attribute.
Reason for the Error
If the SQLSTATE is 42000, this is an error. You attempted to set a CONTROL QUERY DEFAULT setting, but the attribute name you specified is not valid.
If the SQLSTATE is 01000, this is a warning. In an earlier SQL/MX session, you inserted a row into a DEFAULTS table whose attribute column value is invalid.
Solution
Correct the attribute name and resubmit
