SQLCODE -0196 Column &3 in &1 in &2 cannot be dropped.
Explanation
An attempt was made to drop column &3. The column cannot be dropped because a view, a constraint, a trigger, or an index is dependent on the column and RESTRICT was specified, or the column is part of the partition key.User response
Specify CASCADE on the ALTER TABLE statement to drop the column and the views, constraints, triggers, and indexes that are dependent on it. If the column is part of the partition key, specify DROP PARTITIONING on the ALTER TABLE statement to remove the partitioning for the table. Try the request again.SQLSTATE: 42817