Here is my issue:
I altered a CHAR(200) row to VARCHAR(700), by an ALTER command, issued via BMC CATALOG MANAGER. It was successful.
When I tried to ALTER back to CHAR(200) I got an SQLCODE (don't remember) with explanation the column is not the right type.
Any suggestion how to restore column's old chracteristics without a DROP+CREATE?
Thanks in advance,