-876 object-type CANNOT BE CREATED OR ALTERED, REASON reason-code
Explanation
The object in the SQL statement cannot be created or altered.
- object-type
- The type of object that could not be created or altered:
- TYPE 1 INDEX
- The object that the SQL statement attempted to create is a type 1 index.
- INDEX
- The object that the SQL statement attempted to create is an index.
- TABLE
- The object that the SQL statement attempted to create or alter is a table.
- TABLESPACE
- The object that the SQL statement attempted to alter is a table space.
- reason-code
- A value that indicates the reason for the failure.
- TABLE DEFINED AS ASCII
- The underlying table is defined as ASCII. Only type 2 indexes are supported for ASCII tables.
- PIECESIZE IS NOT VALID
- PIECESIZE is only valid for non-partitioned indexes.
- COLUMN NAME IN EBCDIC EXCEEDS 18 BYTES, OR THE CONVERSION FROM UNICODE TO EBCDIC FAILED
- The table that is being created or altered has an edit procedure that is defined with row attribute sensitivity, a field procedure, or a validation procedure. In these cases, the column name in EBCDIC cannot exceed 18 EBCDIC bytes in length, or the conversion of a column name from UNICODE to EBCDIC failed.
- BASE TABLESPACE IS LOG YES, LOB TABLESPACE IS LOG NO
- A spatial index cannot be created because the following table
spaces have the indicated attributes:
- The table space that contains base table has the LOG YES (or LOGGED) attribute.
- The LOB table space that stores the LOB column has the LOG NO (or NOT LOGGED) attribute.
- CONTAINS A SPATIAL COLUMN
- The LOG YES attribute of a LOB table space cannot be altered to LOG NO if an index depends on the LOB column.
- 6
- The value of one of the following subsystem parameters
disallowed the definition of an index-controlled partitioned table:
- PREVENT_NEW_IXCTRL_PART
- The value of the PREVENT INDEX PART CREATE subsystem parameter disallowed the creation of an index-controlled partitioned table with a CREATE TABLE statement.
- PREVENT_ALTERTB_LIMITKEY
- The value of the PREVENT ALTER LIMITKEY subsystem parameter disallowed the alteration of the limit key of an index-controlled partitioned table with an ALTER TABLE statement.
System action
The statement cannot be processed.
Programmer response
Correct the SQL statement for the object that is being created or altered.
SQLSTATE
53092