-650   THE ALTER STATEMENT CANNOT BE EXECUTED, REASON reason-code

The ALTER statement cannot be executed for the indicated reason.

reason-code

A numeric value that indicates the reason that the statement cannot be executed.

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.

7

An ALTER statement with a DSSIZE clause is allowed only for LOB and universal table spaces.

8

An ALTER statement with a SEGSIZE clause is allowed for universal table spaces and partitioned table spaces that use table-controlled partitioning.

9

An ALTER statement with a BUFFERPOOL clause where a different page size is specified is allowed only for LOB and universal table spaces (excluding XML table spaces).

10

An ALTER statement with a MAXPARTITIONS clause is allowed only for the following table spaces:

• Single-table simple table spaces
• Single-table segmented table spaces
• Universal table spaces that use partition-by-growth organization

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 AT clause is not allowed when using table-controlled partitioning.

15

Using ALTER to change the attributes of a partition values is not allowed for an index on a partitioned base table with LOB columns, or the table itself.

16

ALTER TABLE DATA CAPTURE CHANGES is not allowed for table spaces in advisory REORG-pending (AREO) state.

17

ALTER TABLE DROP CLONE cannot be used to drop a clone when the table itself is a clone.

18

ALTER INDEX is not allowed when the table has defined a clone.

19

ALTER TABLESPACE is not allowed when the table space contains a table that has a clone defined.

20

ALTER TABLE DROP CLONE cannot be used to drop a clone when the table does not have a defined clone.

21

ALTER TABLE SET DEFAULT is not allowed when all of the following conditions are true:

• The table exists in a table space that currently has the DEFINE YES attribute.
• The ALTER TABLE statement references a column that was not part of the original table definition.
• The table has not been reorganized since the referenced column was added.

22

ALTER TABLE SET DEFAULT and DROP DEFAULT are not allowed for tables referenced by a materialized query table or view.

23

ALTER TABLE DROP DEFAULT is not allowed when the table space is in the advisory REORG-pending (AREO*) state.

25

ALTER TABLE DROP DEFAULT is not allowed when all of the following conditions are true:

• The table space is in either the advisory REORG-pending (AREO*) or REORG-pending (REORP) state.
• The ALTER TABLE statement references a column that was not part of the original table definition.
• The table has not been reorganized since the referenced column was added.

In this case, a mass UPDATE can be used to clear the AREO* state.

28

ALTER TABLE is not allowed for an accelerator-only table unless the only alteration that is specified is either ADD RESTRICT ON DROP or DROP RESTRICT ON DROP.

29

ALTER TABLESPACE is not allowed when the table space contains an accelerator-only table.