Neoview Messages Manual (R2.3)

Table 24-7 SQLSTATE Values Beginning 42000 (continued)
Error TextSQLCODESQLSTATE
Duplicate UPDATE rules specified.-305642000
Invalid size value in the ALLOCATE clause.-305742000
The BLOCKSIZE value must be 4096.-305842000
Invalid size value in the MAXSIZE clause.-305942000
Invalid percentage value in the DSLACK clause.-306042000
The format of the specified location name name is invalid.
-306142000
Duplicate MAXSIZE clauses in the PARTITION clause.-306242000
Duplicate DSLACK clauses in the PARTITION clause.-306342000
Duplicate ISLACK clauses in the PARTITION clause.-306442000
The primary key constraint cannot be droppable when the STORE BY PRIMARY KEY
clause appears in a table definition.
-306542000
ALTER TABLE ADD CONSTRAINT allows only DROPPABLE constraints.-306742000
The ALLOCATE and DEALLOCATE clauses cannot coexist in the same ALTER INDEX
statement.
-306842000
Duplicate [NO]AUDITCOMPRESS clauses.-307142000
The BLOCKSIZE clause is not allowed in the ALTER INDEX ... ATTRIBUTE(S)
statement.
-307242000
Duplicate [NO]BUFFERED clauses.-307342000
Duplicate [NO]CLEARONPURGE clauses.-307442000
The [NO]COMPRESS clause is not allowed in the ALTER INDEX ... ATTRIBUTE(S)
statement.
-307542000
Duplicate DEALLOCATE clauses.-307642000
The [NO]ICOMPRESS clause is not allowed in the ALTER INDEX ... ATTRIBUTE(S)
statement.
-307742000
The LOCKLENGTH clause is not allowed in the ALTER INDEX ... ATTRIBUTE(S)
statement.
-307842000
Duplicate MAXSIZE clauses.-307942000
Duplicate ALLOCATE clauses.-308142000
Duplicate [NO]AUDIT clauses.-308242000
Duplicate [NO]AUDITCOMPRESS clauses.-308342000
The BLOCKSIZE clause is not allowed in the ALTER TABLE ... ATTRIBUTE(S)
statement.
-308442000
Duplicate [NO]BUFFERED clauses.-308542000
Duplicate [NO]CLEARONPURGE clauses.-308642000
The [NO]COMPRESS clause is not allowed in the ALTER TABLE ... ATTRIBUTE(S)
statement.
-308742000
The ALLOCATE AND DEALLOCATE cannot coexist in the same ALTER TABLE
statement.
-308842000
The [NO]ICOMPRESS clause is not allowed in the ALTER TABLE ... ATTRIBUTE(S)
statement.
-308942000
Duplicate LOCKLENGTH clauses.-309042000
SQLSTATE Values 455