Neoview Messages Manual (Volume 1) (R2.4)

5 Binder and Compilation Messages (4000 Through 4999)
SQL 4000
4000 Internal error in the query binder.
Cause The HP Neoview database software received an internal error in the query binder.
Effect The Neoview database software is unable to process this query.
Recovery Do not attempt recovery. HP support will perform recovery operations in response
to an automatically generated dial-out message about this condition.
SQL 4001
4001 Column name1 is not found. Tables in scope: name2. Default schema:
name3.
Cause You referenced column name1, which the HP Neoview database software 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.
SQL 4002
4002 Column name1 is not found. Table name2 not exposed. Tables in
scope: name3. Default schema: name4.
Cause You referenced column name1, which the HP Neoview database software could not
find. Table name2 is not exposed. The table name3 or tables in the scope of the column
reference and the default schema name4 appear.
Effect The operation fails.
Recovery Correct the syntax so that the table and column can be found, and resubmit.
SQL 4003
4003 Column name1 is not a column in table name2, or, after a NATURAL
JOIN or JOIN USING, is no longer allowed to be specified with a table
correlation name.
127