Hi,

I was adding columns to existing table.
As per the general convention in our installation, the column is added
with NOT NULL DEFAULT.

Now that user comes back and says that these columns are exception to
installation standards, and wants the columns to allow NULL.

How do I achieve this ?

I was trying
alter table test.jnl_ety alter column dpt_cd set data type char 3
(earlier dpt_cd is added as char(3) not null with default )
When I am running the above query, it is giving me error.

Please help me out in this.


Thanks & Regards,
Ravi.


DB2 & UDB email list listserv db2-l LazyDBA home page