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

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Messages Manual—523730-004
6-2
SQL 4002
Cause. You referenced column name1, which SQL/MX 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
Cause. You either attempted to select column name1, which does not exist, or
referenced a column that is included in a NATURAL JOIN or JOIN USING and is now a
common column. If a column is part of a JOIN operation, you no longer qualify its
name with its original table name2.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit. If the column is part of a JOIN, remove
the table qualifier and use only the column name.
SQL 4004
Cause. You referenced column name1, whose parent table is ambiguous. The table
names or tables in the scope of the column reference and default schema name2
appear.
Effect. The operation fails.
Recovery. Correct the syntax so that the table's parent table is clear, and resubmit.
4002 Column name1 is not found. Table name2 not exposed.
Tables in scope: name3. Default schema: name4.
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.
4004 Column name name1 is ambiguous. Tables in scope: names.
Default schema: name2.