SQL/MP Messages Manual

SQL Compiler Binder Messages (4000 to 4999)
HP NonStop SQL/MP Messages Manual—427720-006
6-22
SQL 4094
Cause. An ORDER BY clause was specified in one or more SELECT statements in
the UNION clause.
Effect. The statement does not compile.
Recovery. Specify only one ORDER BY clause as the last clause following the final
SELECT statement after the UNION operator.
SQL 4097
Cause. UNION cannot be in the query expression of a CREATE PROTECTION VIEW
statement.
Effect. The statement does not compile.
Recovery. Do not specify a UNION operator when you are creating a protection view,
or do not specify FOR PROTECTION for a view that contains a UNION operator.
SQL 4098
Cause. An SQLCI user specified a FOR UPDATE OF clause in the SELECT
statement. A FOR UPDATE OF clause can be in a SELECT statement only within a
DECLARE CURSOR FOR statement.
Effect. The statement does not compile.
Recovery. Do not specify FOR UPDATE OF with this SELECT statement.
4094 Only one ORDER BY clause can be specified for the result
of a UNION operation, and it must follow the last SELECT
statement.
4097 A protection view cannot contain a UNION operator.
4098 This SELECT cannot have a FOR UPDATE OF clause.