logo  
Google
 

DB2 SQL-Error: -876

SQLState: 53092

Short Description: CANNOT BE CREATED OR ALTERED REASON

The object, object, cannot be created in the SQL statement. Possible values for object: TYPE 1 INDEX The object being created is a type 1 index. INDEX The object being created is an index. TABLE The object being created or altered is a table. Possible values for reason: 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 being created or altered has an EDITPROC, FIELDPROC, or VALIDPROC, in which case the column name in EBCDIC cannot exceed 18 EBCDIC bytes in length, or the conversion of a column name from UNICODE to EBCDIC failed.System action: The statement cannot be executed. Programmer response: Correct the SQL statement for the object being created.

 <-  BACK TO INDEX