Rahul B wrote:
Hi,
Why is it that an Alter statement on a table adding a not null column
gives an error "SQL0193N" even though the table has no rows.
I guess DB2 should see that since there are no rows in the table, we
can just go ahead and add the not nullable column.
I am sure there is some specific reason that DB2 doesn't allow the
addition of not null columns to a table already created but having no
rows.
Add a WITH DEFAULT clause
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab