SQL/MP Messages Manual

SQL Compiler Parser Messages (3000 to 3999)
HP NonStop SQL/MP Messages Manual—427720-006
5-19
SQL 3070
Cause. You specified RETURN IF LOCKED and WAIT IF LOCKED in the same SQL
statement.
Effect. The statement does not compile.
Recovery. Choose one option, remove the other, and recompile.
SQL 3071
Cause. You specified both the SKIP UNAVAILABLE PARTITION clause and the STOP
AT UNAVAILABLE PARTITION clause in the same SQL statement.
Effect. The statement fails.
Recovery. Choose one option, remove the other, and recompile.
SQL 3072
Cause. You specified both SHARE and EXCLUSIVE mode in an SQL statement.
Effect. The statement does not compile.
Recovery. Choose one option, remove the other, and recompile.
SQL 3073
Cause. You specified both BROWSE ACCESS and one of the lock modes
(EXCLUSIVE or SHARE) in the SQL statement.
Effect. The statement does not compile.
Recovery. If you want BROWSE ACCESS, remove the lock mode option. If you want
the lock mode, remove the BROWSE ACCESS clause or replace it with STABLE
ACCESS or REPEATABLE ACCESS.
3070 You cannot specify RETURN IF LOCKED and WAIT IF LOCKED
in the same SQL statement.
3071 You cannot specify SKIP UNAVAILABLE PARTITION and STOP
AT UNAVAILABLE PARTITION in the same SQL statement.
3072 You cannot specify SHARE and EXCLUSIVE in the same SQL
statement.
3073 You cannot specify EXCLUSIVE or SHARE with BROWSE
ACCESS.