SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-7
SQL 4029
Cause. The select list of the query expression defining a view contained an
expression, and no name was specified in the column list of the CREATE VIEW
statement. If the column list was omitted, the names of the columns in the select list
were used. If the select list contained an expression, however, no name could be
derived.
Effect. The statement does not compile.
Recovery. Supply a name for each column in the view definition.
SQL 4030
Cause. The statement required the name of an SQL table. The specified object
referred to an existing SQL object that was not a table, such as a view or index. You
might be attempting an operation that is not allowed on the object type; for example,
ADD COLUMN on a view or DROP TABLE on a view.
Effect. The statement does not compile.
Recovery. Check the specified object name for correctness. Check the semantics of
the SQL statement.
SQL 4031
Cause. The statement required the name of an SQL index. The specified object
referred to an existing SQL object that was not an index, such as a table or view. You
might be trying an operation that is not allowed on the object type; for example, DROP
INDEX.
Effect. The statement does not compile.
Recovery. Check the specified object name for correctness. Check the semantics of
the SQL statement.
4029 A column name must be provided for a view expression
column.
4030 Object value-1 is not an SQL table.
4031 Object value-1 is not an SQL index.