-148   THE SOURCE TABLE OR TABLESPACE source-name CANNOT BE ALTERED, REASON reason-code

The ALTER statement issued could not be processed.

source-name

The name of the source table or table space.

reason-code

The reason for the message or SQL code, indicated by one of the following values:

01

The ALTER statement specified an ALTER COLUMN clause that attempted to drop the default value, alter the default value, or change the length of the column. The column cannot be altered because the column has a field procedure or is involved in a referential or check constraint. The default value cannot be changed because the column has a field procedure.

02

The ALTER statement specified an ALTER COLUMN clause that attempted to drop the default value, alter the default value, or change the length of the column. The column cannot be altered because the table that is identified by source-name might be one of the following:

• A table that has an edit procedure or validation procedure.

03

The ALTER statement specified an ALTER COLUMN clause that attempted to drop the default value, alter the default value, or alter the data type of the column. The column cannot be altered because the table is defined with DATA CAPTURE CHANGES and the subsystem parameter RESTRICT_ALT_COL_FOR_DCC is set to YES.

04

The ALTER statement cannot be used to define a clone table because a clone table is already defined for source-name.

05

The ALTER statement cannot be used to define a clone table because table source-name is not in a universal table space or it is in a table space that is defined with PAGENUM RELATIVE.

06

The ALTER statement cannot be used to define a clone table because table source-name is involved in a referential or check constraint.

07

The ALTER statement cannot be used to define a clone table because table source-name has an after trigger defined on it.

08

The ALTER statement cannot be used to define a clone table because table source-name is a materialized query table.

09

The ALTER statement cannot be used to define a clone table because table source-name has more than one table space version or index version in use.

10

Either of the following reasons:

The ALTER statement cannot be used to define a clone table because table space of table source-name or an index on table source-name was created with DEFINE NO, and the data set is not yet defined.

An auxiliary object for a source table with a LOB or XML column was created with DEFINE NO, and the data set is not yet defined

11

The ALTER statement attempted to change a table that has a defined clone, or a table that is a clone.

12

The ALTER statement cannot be used to define a clone table because table source-name is defined with an edit procedure, validation procedure, or field procedure.

13

The ALTER statement cannot be processed because an index exceeds versioning limit of 16.

14

An ALTER statement with an ALTER COLUMN clause attempted to change the data type from character FOR BIT DATA to BINARY, but the cast default value length exceeds 1536 UTF-8 bytes.

15

The ALTER statement cannot be processed because no pending changes are associated with the table space.

16

An ALTER TABLESPACE statement cannot include the MEMBER CLUSTER YES option for hash-organized table space.

17

The ALTER statement cannot be used to define a clone table because table source-name is hash-organized.