Can not drop a column from a table. I do have all the relevant previlages.
Error message
Drop failed. Function not supported (Reason code = "100").. SQLCODE=-270, SQLSTATE=42997, DRIVER=3.57.86

Any idea?

Thanks

SQL0270N
Function not supported (Reason code = reason-code).
Explanation:
The statement cannot be processed because it violates a restriction as indicated by the following reason code:
...
100
Drop column, and alter nullability is not allowed on any table with data capture on.

Figured out that was a confusion in the previlages. Unpredicted behaviour in Control Center and the IBM data studio.

In fact it is possible to drop a column containing data. Have also noticed that column names must be in upper case otherwise everything gets very messy.

DB2 will automatically convert column names to upper case, unless you specified them as delimited names. So that shouldn't be a problem. And if you have wrong privileges, you'd get a different error. I agree with n_i that the error code tells you exactly what is wrong.