SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-17
SQL 4060
Cause. The statement required an SQL table or view name, but no SQL table or view
with the indicated name existed.
Effect. If the message is a warning at compile time, the table or view must exist before
the statement executes. The statement is left uncompiled until an attempt is made to
recompile it or execute it.
Recovery. Create the table or view before executing the statement.
SQL 4061
Cause. The statement required an SQL index name, but no SQL index with the
indicated name existed.
Effect. If the message is a warning at compile time, the index must exist before the
statement executes. The statement is left uncompiled until an attempt is made to
recompile it or execute it.
Recovery. Create the index before executing the statement.
SQL 4062
Cause. The statement required a column list and a value list, but these lists had a
different number of elements. The INSERT statement requires that the insert column
list and the supplied value list contain the same number of elements. If you omit the
insert column list, you must supply a value for every column in the table or view. If you
want to supply a subset of values, the INSERT statement must explicitly specify the
columns in the column list. A common mistake is to INSERT INTO T1 SELECT *
FROM T2, when T1 and T2 do not have the same number of columns.
Effect. The statement does not compile.
Recovery. Check the column list and value list. If you omit the column list, ensure that
the value list contains a value for every column in the table.
4060 Table or view value-1 could not be found.
4061 Index value-1 could not be found.
4062 The number of values supplied is not the same as the
number of columns.