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

SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—523730-004
20-14
SQLSTATE Values
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.
0172B 3083 Duplicate [NO]AUDITCOMPRESS clauses.
0172C 3084 The BLOCKSIZE clause is not allowed in the ALTER TABLE ...
ATTRIBUTE(S) statement.
0172D 3085 Duplicate [NO]BUFFERED clauses.
0172E 3086 Duplicate [NO]CLEARONPURGE clauses.
0172F 3087 The [NO]COMPRESS clause is not allowed in the ALTER
TABLE ... ATTRIBUTE(S) statement.
0172G 3088 The ALLOCATE AND DEALLOCATE cannot coexist in the
same ALTER TABLE statement.
0172H 3089 The [NO]ICOMPRESS clause is not allowed in the ALTER
TABLE ... ATTRIBUTE(S) statement.
0172I 3090 Duplicate LOCKLENGTH clauses.
Table 20-1. SQLSTATE Values (page 13 of 85)
SQLSTATE SQLCODE Error Text