SQLSTATE Values Returned by NonStop SQL/MX
HP NonStop SQL/MX Messages Manual—640324-001
21-54
SQLSTATE Values
42000 -3084 The BLOCKSIZE clause is not allowed in the ALTER TABLE ...
ATTRIBUTE(S) statement.
42000 -3085 Duplicate [NO]BUFFERED clauses.
42000 -3086 Duplicate [NO]CLEARONPURGE clauses.
42000 -3087 The [NO]COMPRESS clause is not allowed in the ALTER
TABLE ... ATTRIBUTE(S) statement.
42000 -3088 The ALLOCATE AND DEALLOCATE cannot coexist in the
same ALTER TABLE statement.
42000 -3089 The [NO]ICOMPRESS clause is not allowed in the ALTER
TABLE ... ATTRIBUTE(S) statement.
42000 -3090 Duplicate LOCKLENGTH clauses.
42000 -3091 The [NO]AUDIT clause is not allowed in the CREATE INDEX
statements.
42000 -3092 Duplicate BLOCKSIZE clauses.
42000 -3093 Duplicate DCOMPRESS clauses.
42000 -3094 The DEALLOCATE clause is not allowed in the CREATE
INDEX statements.
42000 -3095 Duplicate [NO]ICOMPRESS clauses.
42000 -3096 Duplicate [NO]SERIALWRITES clauses.
42000 -3097 The DEALLOCATE clause is not allowed in the CREATE
TABLE statements.
42000 -3098 Duplicate LOCATION clauses.
42000 -3099 Duplicate FILE ATTRIBUTE(S) clauses.
42000 -3100 Duplicate DSLACK clauses.
42000 -3101 Duplicate ISLACK clauses.
42000 -3102 Duplicate PARALLEL EXECUTION clauses.
42000 -3103 Duplicate PARTITION clauses.
42000 -3104 Only the ADD option is allowed in a PARTITION clause in a
CREATE TABLE statement.
42000 -3106 Duplicate PRIMARY KEY clauses.
42000 -3107 Duplicate LIKE clauses.
42000 -3108 The LIKE clause and STORE BY clause cannot coexist in the
same statement.
42000 -3109 Duplicate STORE BY clauses.
42000 -3110 The LIKE clause and ATTRIBUTE(S) clause cannot coexist in
the same statement.
Table 21-1. SQLSTATE Values (page 53 of 84)
SQLSTATE SQLCODE Error Text
To Next Page