In this blog post, let’s learn about the error message “1009 Column column-name does not exist in the specified table.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
1009 Column column-name does not exist in the specified table.
Reason for the Error
The referenced table does not have a column with this name.
Solution
Replace either the table name or the column name (whichever is incorrect) and resubmit