Is it possible to set a default value to a column in SQLBase?

Question

Does SQL Base have an option to set a DEFAULT Value to a column? Like

ALTER TABLE blablub MODIFY test SET DEFAULT '0'

Solution, thanks to Grzegorz Oledzki:

ALTER TABLE blablub MODIFY test NOT NULL WITH DEFAULT

However kinda stupid since you can't define the DEFAULT value yourself.

Answer 1

This is the first time I hear of SQLBase, but after googling I found the documentation which at page 3-11 suggests something like:

ALTER TABLE blablub MODIFY test <DATATYPE> NOT NULL WITH DEFAULT