SQL/MP Messages Manual

HP NonStop SQL/MP Messages Manual—427720-006

6-1

SQL Compiler Binder Messages

(4000 to 4999)

SQL 4002

Cause. The specified column was not found in any table in the FROM clause or in any

table of an outer query FROM clause. Either the column name is misspelled, or the

table containing the column is not specified in the query at the level of the error or in

any outer query.

Effect. The statement does not compile.

Recovery. Check the column names of the tables that can apply at the level of the

error.

SQL 4003

Cause. The specified column name represents a column in more than one table in the

same FROM clause. Every column name specified must uniquely identify a column

within the current FROM clause.

Effect. The statement does not compile.

Recovery. Specify a correlation name for the column so that the correlation name

indicates the table that contains the column.

SQL 4004

Cause. The statement requires the name of an SQL table or view, and the specified

object was not a table or a view. Perhaps you attempted an operation that is not

allowed on the object type; for example, selecting from an index.

Effect. The statement does not compile.

Recovery. Correct the object name and reissue the statement.

4002 Column value-1 could not be found.

4003 value-1 is an ambiguous column reference.

4004 Object value-1 is not an SQL table or view.