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-15
SQLSTATE Values
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.
0172J 3091 The [NO]AUDIT clause is not allowed in the CREATE INDEX
statements.
0172K 3092 Duplicate BLOCKSIZE clauses.
0172L 3093 Duplicate DCOMPRESS clauses.
0172M 3094 The DEALLOCATE clause is not allowed in the CREATE
INDEX statements.
0172N 3095 Duplicate [NO]ICOMPRESS clauses.
0172O 3096 Duplicate [NO]SERIALWRITES clauses.
0172P 3097 The DEALLOCATE clause is not allowed in the CREATE
TABLE statements.
0172Q 3098 Duplicate LOCATION clauses.
0172R 3099 Duplicate FILE ATTRIBUTE(S) clauses.
0172S 3100 Duplicate DSLACK clauses.
0172T 3101 Duplicate ISLACK clauses.
0172U 3102 Duplicate PARALLEL EXECUTION clauses.
0172V 3103 Duplicate PARTITION clauses.
0172W 3104 Only the ADD option is allowed in a PARTITION clause in a
CREATE TABLE statement.
0172X 3105 Currently only range, hash and system partitioning are
supported.
0172Y 3106 Duplicate PRIMARY KEY clauses.
0172Z 3107 Duplicate LIKE clauses.
01730 3108 The LIKE clause and STORE BY clause cannot coexist in the
same statement.
01731 3109 Duplicate STORE BY clauses.
Table 22-1. SQLSTATE Values (page 14 of 84)
SQLSTATE SQLCODE Error Text