SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-6
SQL 4024
Cause. A CREATE VIEW statement contained a column list with a different number of
columns than elements in the select list in the defining query expression. If you want to
specify new names for the columns in the view, the statement must supply a name for
each column or expression in the select list.
Effect. The statement fails.
Recovery. Specify a name in the CREATE VIEW column list for each element in the
select list of the query expression.
SQL 4025
Cause. The query expression used to define a protection view contains a subquery.
Effect. The statement fails.
Recovery. Use a shorthand view.
SQL 4026
Cause. In the query expression that defined the protection view, a column was
referred to in the WHERE clause but was not in the select list.
Effect. The statement does not compile.
Recovery. Include in the select list all columns referred to in the WHERE clause.
4024 The view column list and the select column list have a
different number of elements.
4025 A protection view definition cannot contain a subquery.
4026 All columns in the WHERE clause of a protection view
definition must also appear in the select list.