In this blog post, let’s learn about the error message “4002 Column name1 is not found. Table name2not exposed. Tables in scope:name3. Default schema: name4.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4002 Column name1 is not found. Table name2not exposed. Tables in scope:name3. Default schema: name4.
Reason for the Error
You referenced column name1 , which NonStop SQL/MX could not find. Table name2is not exposed. The table name3 or tables in the scope of the column reference and the default schema name4 appear.
Solution
Correct the syntax so that the table and column can be found, and resubmit
