On 12/20/06, Nick Upson <nick.upson@...> wrote:

> that's what I thought but :
>
> SQL> ALTER TABLE tblsystemstatus add test Integer DEFAULT 0 NOT NULL;
> SQL> commit;
> SQL> select * from tblsystemstatus;
>
> LOGLIST TEST
> ==================================== ============
> ABCD 0
>
> hence my confusion

I think a few days ago I read on the same subject that ISQL (and maybe
one other tool?) will display zero/empty string for a newly added
not-null-field with a default value.
AFAIK your field value is indeed NULL.

Try reading the value using another tool or by writing a small test application.

HTH,
Markus