DB2 SQL-Error: -650

Short Description: THE ALTER STATEMENT CANNOT BE EXECUTED REASON C AT U ALTER ALTER TABLE DATA CAPTURE CHANGES A REORG P S T ALTER P C

The ALTER statement cannot be executed for one of the following reasons: 1 Alter to type 1 index is not allowed for the index whose associated table space has a LOCKSIZE specification of ROW. 2 Alter to type 1 index is not allowed for the index defined with UNIQUE WHERE NOT NULL. 3 Alter to type 1 index is not allowed for the index whose associated table space has been defined as a LARGE table space. 4 Alter to type 1 index is not allowed for an index on an ASCII table. 5 An ALTER statement with a PIECESIZE clause is not allowed for a partitioning index. 6 An ALTER statement with a PIECESIZE 4G clause is not allowed for non-partitioned indexes on a non-large table. 11 An ALTER statement with an ENDING AT clause is not allowed for an index on a partitioned base table with LOB columns or the table itself. 12 ALTER INDEX is not allowed when there is a pending SQL statement. 13 ALTER TABLE is not allowed when there is a pending SQL statement. 14 An ALTER INDEX statement with an ENDING

 <-  BACK TO INDEX