In this blog post, let’s learn about the error message “4001 Column name1 is not found. Tables in scope: name2. Default schema:name3.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
4001 Column name1 is not found. Tables in scope: name2. Default schema:name3.
Reason for the Error
You referenced column name1, which NonStop SQL/MX could not find. The table name2 or tables in the scope of the column reference and the default schema name3 appear.
A common reason for this error is that you have used double quotes instead of single quotes. For example:
>>select * from tb where b > “b”;
result in this error:
*** ERROR[4001] Column “b” is not found. Tables in scope: CAT.SCH.TB. Default schema: CAT.SCH.
In this example, the user specified double quotes, which indicate a delimited identifier, rather than single quotes, which indicate an alpha literal.
The user probably intended:
>>select * from tb where b > ‘b’;– alpha literal
or
>>select * from tb where b > “v”;– table tb (a int, b char, “v” char)
Solution
Correct the syntax so that the table and column can be found, and resubmit
