SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—640324-001
21-53
SQLSTATE Values
42000 -3052 Duplicate NOT NULL clauses in column definition name.
42000 -3053 Duplicate PRIMARY KEY clauses in column definition name.
42000 -3054 The NOT DROPPABLE clause is allowed only in PRIMARY
KEY and NOT NULL constraint definitions.
42000 -3055 Duplicate DELETE rules specified.
42000 -3056 Duplicate UPDATE rules specified.
42000 -3057 Invalid size value in the ALLOCATE clause.
42000 -3058 The BLOCKSIZE value must be 4096 or 32768.
42000 -3059 Invalid size value in the MAXSIZE clause.
42000 -3060 Invalid percentage value in the DSLACK clause.
42000 -3061 The format of the specified location name name is invalid.
42000 -3062 Duplicate MAXSIZE clauses in the PARTITION clause.
42000 -3063 Duplicate DSLACK clauses in the PARTITION clause.
42000 -3064 Duplicate ISLACK clauses in the PARTITION clause.
42000 -3065 The primary key constraint cannot be droppable when the
STORE BY PRIMARY KEY clause appears in a table
definition.
42000 -3067 ALTER TABLE ADD CONSTRAINT allows only DROPPABLE
constraints.
42000 -3068 The ALLOCATE and DEALLOCATE clauses cannot coexist in
the same ALTER INDEX statement.
42000 -3071 Duplicate [NO]AUDITCOMPRESS clauses.
42000 -3072 The BLOCKSIZE clause is not allowed in the ALTER INDEX ...
ATTRIBUTE(S) statement.
42000 -3073 Duplicate [NO]BUFFERED clauses.
42000 -3074 Duplicate [NO]CLEARONPURGE clauses.
42000 -3075 The [NO]COMPRESS clause is not allowed in the ALTER
INDEX ... ATTRIBUTE(S) statement.
42000 -3076 Duplicate DEALLOCATE clauses.
42000 -3077 The [NO]ICOMPRESS clause is not allowed in the ALTER
INDEX ... ATTRIBUTE(S) statement.
42000 -3078 The LOCKLENGTH clause is not allowed in the ALTER INDEX
... ATTRIBUTE(S) statement.
42000 -3079 Duplicate MAXSIZE clauses.
42000 -3081 Duplicate ALLOCATE clauses.
42000 -3082 Duplicate [NO]AUDIT clauses.
42000 -3083 Duplicate [NO]AUDITCOMPRESS clauses.
Table 21-1. SQLSTATE Values (page 52 of 84)
SQLSTATE SQLCODE Error Text
To Next Page