SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
22-14
SQLSTATE Values
0171H 3053 Duplicate PRIMARY KEY clauses in column definition name.
0171I 3054 The NOT DROPPABLE clause is allowed only in PRIMARY
KEY and NOT NULL constraint definitions.
0171J 3055 Duplicate DELETE rules specified.
0171K 3056 Duplicate UPDATE rules specified.
0171L 3057 Invalid size value in the ALLOCATE clause.
0171M 3058 The BLOCKSIZE value must be 4096 or 32768.
0171N 3059 Invalid size value in the MAXSIZE clause.
0171O 3060 Invalid percentage value in the DSLACK clause.
0171P 3061 The format of the specified location name name is invalid.
0171Q 3062 Duplicate MAXSIZE clauses in the PARTITION clause.
0171R 3063 Duplicate DSLACK clauses in the PARTITION clause.
0171S 3064 Duplicate ISLACK clauses in the PARTITION clause.
0171T 3065 The primary key constraint cannot be droppable when the
STORE BY PRIMARY KEY clause appears in a table
definition.
0171V 3067 ALTER TABLE ADD CONSTRAINT allows only DROPPABLE
constraints.
0171W 3068 The ALLOCATE and DEALLOCATE clauses cannot coexist in
the same ALTER INDEX statement.
0171Y 3070 The [NO]AUDIT clause is not supported.
0171Z 3071 Duplicate [NO]AUDITCOMPRESS clauses.
01720 3072 The BLOCKSIZE clause is not allowed in the ALTER INDEX ...
ATTRIBUTE(S) statement.
01721 3073 Duplicate [NO]BUFFERED clauses.
01722 3074 Duplicate [NO]CLEARONPURGE clauses.
01723 3075 The [NO]COMPRESS clause is not allowed in the ALTER
INDEX ... ATTRIBUTE(S) statement.
01724 3076 Duplicate DEALLOCATE clauses.
01725 3077 The [NO]ICOMPRESS clause is not allowed in the ALTER
INDEX ... ATTRIBUTE(S) statement.
01726 3078 The LOCKLENGTH clause is not allowed in the ALTER INDEX
... ATTRIBUTE(S) statement.
01727 3079 Duplicate MAXSIZE clauses.
01728 3080 The [NO]SERIALWRITES clause is not supported.
01729 3081 Duplicate ALLOCATE clauses.
0172A 3082 Duplicate [NO]AUDIT clauses.
Table 22-1. SQLSTATE Values (page 13 of 84)
SQLSTATE SQLCODE Error Text