HP NonStop SQL/MX, Messages Manual

Page: 187 / 752

HP NonStop SQL/MX Messages Manual —640324-001
6 -1
6
Binder and Compilation Messages
(4000 through 4999)
SQL 4000
Cause. NonStop SQL/MX received an internal error in the query binder.
Effect. NonStop SQL/MX is unable to process this query.
Recovery. None. Report the entire message to your service provider.
SQL 4001
Cause. 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)
Effect. The operation fails.
Recovery. Correct the syntax so that the table and column can be found, and
resubmit.
4000 Internal error in the query binder.
4001 Column name1 is not found. Tables in scope: name2 .
Default schema: name3 .