SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-2
SQL 4006
Cause. You specified a column name more than once for a unique column list, and
SQL/MP requires that this list contain unique column names only.
Effect. The statement does not compile.
Recovery. Rename the duplicate column or remove the duplicate column from the
SQL statement.
SQL 4007
Cause. You qualified a column with a correlation name that was not defined in the
FROM clause or could not be derived from the table names in the FROM clause, or
was not in scope. You might have misspelled the correlation name, omitted the
correlation name in the FROM clause, specified a correlation name for a table in the
FROM clause and then used the table name for a correlation on a column name, or
used a correlation name that was not in the current scope. For a subquery, the scope
is the FROM clause of that query and any outer query. For a join query, the scope is
the tables or join tables that are part of the join operation.
Effect. The statement does not compile.
Recovery. Check that the correlation name for the table is properly defined, and
reissue the statement.
SQL 4008
Cause. The specified correlation name occurred more than once in a single FROM
clause. This error can happen because each table name in the FROM clause has a
default correlation name that is used if you do not specify one. Each correlation name
in the FROM clause must be unique. Therefore, if the same table name appears in a
FROM clause, you must supply a correlation name to identify each table uniquely.
Effect. The statement does not compile.
Recovery. Specify a unique correlation name for the duplicate name in the FROM
clause.
4006 value-1 is a duplicate column name.
4007 Correlation name value-1 could not be found.
4008 value-1 is a duplicate correlation name.