SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001

6-1

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

>>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.