SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Parser and Compilation Messages (3000 through
3999)
HP NonStop SQL/MX Messages Manual—523730-004
5-17
SQL 3065
Cause. You defined a primary key as droppable in a table that includes STORE BY
PRIMARY KEY in its definition, which is not supported.
Effect. SQL/MX is unable to process this definition.
Recovery. Change the definition of the primary key constraint so that it is NOT
DROPPABLE.
SQL 3067
Cause. You specified an ALTER TABLE ADD CONSTRAINT statement with NOT
DROPPABLE constraints. Only DROPPABLE constraints are allowed.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
SQL 3068
Cause. You specified an ALTER INDEX statement with both an ALLOCATE and a
DEALLOCATE clause, which is not supported.
Effect. SQL/MX ignores the ALTER INDEX statement.
Recovery. Correct the ALTER INDEX statement to include either ALLOCATE or
DEALLOCATE.
SQL 3070
Cause. You specified the [NO]AUDIT clause, which is not supported.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
3065 The primary key constraint cannot be droppable when the
STORE BY PRIMARY KEY clause appears in a table definition.
3067 ALTER TABLE ADD CONSTRAINT allows only DROPPABLE
constraints.
3068 The ALLOCATE and DEALLOCATE clauses cannot coexist in
the same ALTER INDEX statement.
3070 The [NO]AUDIT clause is not supported.