SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

HP NonStop SQL/MX Messages Manual—523730-004
6-1
6
Binder and Compilation Messages
(4000 through 4999)
SQL 4000
Cause. SQL/MX received an internal error in the query binder.
Effect. 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 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.