SQL/MP Messages Manual

SQL Compiler Parser Messages (3000 to 3999)
HP NonStop SQL/MP Messages Manual—427720-006
5-20
SQL 3074
Cause. You specified the COUNT function and the ALL option.
Effect. The statement does not compile.
Recovery. Remove the ALL option when you specify the COUNT function, and
recompile.
SQL 3075
Cause. You specified both a WHERE search condition and a WHERE CURRENT OF
cursor name clause in the DELETE or UPDATE statement.
Effect. The statement does not compile.
Recovery. Specify either the WHERE search condition or the WHERE CURRENT OF
cursor name clause and recompile.
SQL 3076
Cause. You specified an ORDER BY clause in the SELECT command of a CREATE
VIEW statement.
Effect. The statement does not compile.
Recovery. Correct the syntax and recompile.
SQL 3077
Cause. Stated in the error message.
Effect. The statement does not compile.
Recovery. Specify the LIKE option without ORGANIZATION, CLUSTERING KEY,
SIMILARITY CHECK, PARTITION ARRAY, or FORMAT, and recompile.
3074 You cannot specify COUNT when ALL is specified.
3075 You cannot specify a WHERE search condition and a WHERE
CURRENT OF cursor name in the same DELETE or UPDATE
statement.
3076 You cannot specify an ORDER BY clause in the SELECT
command of a CREATE VIEW statement.
3077 If you specify the LIKE option, you cannot specify
ORGANIZATION, CLUSTERING KEY, SIMILARITY CHECK, PARTITION
ARRAY, or FORMAT.