ADB7145I Column `column_name` cannot be altered by the ALTER TABLE ALTER COLUMN SET WITH DEFAULT statement. Reason code `reason_code`.

Explanation
The table cannot be altered due to DB2® restrictions. The table will be dropped and re-created. See the following list for an explanation of the reason code: 

1

The table must not be referenced by a view or a Materialized Query Table (MQT).

2

For LOB columns, only the default for inline LOB columns can be changed. The new default length
cannot be greater than the inline length.

System action
Processing continues.

User response
No action is required.

ADB7145I Column column_name cannot be altered by the ALTER TABLE ALTER COLUMN SET WITH DEFAULT statement. Reason code reason_code.

Explanation

System action

User response

ADB7145I Column `column_name` cannot be altered by the ALTER TABLE ALTER COLUMN SET WITH DEFAULT statement. Reason code `reason_code`.