IBM Informix Dynamic Server Version 11.10.UC1

Could someone please confirm to me that the only way to drop a default column value in Informix is to basically alter the column to itself minus the default - for example.

Add the default:
ALTER TABLE mytab MODIFY mycol varchar(10) default 'x'
Remove the default:
ALTER TABLE mytab MODIFY mycol varchar(10)

i.e there is no equivalent command to DB2's
ALTER TABLE mytab ALTER COLUMN mycol DROP DEFAULT

thanks for any replies to this.

Andy

If I wouldn't have access to the dbaccess utility I would try that yes. In dbaccess you can change it with the subsequent options "Table", "Alter", "Constraints", "Defaults" and "Drop".

Regards,
Hans