Hello....

I created one table having 3 columns namely(no,name,dept).i want to make column 'no' as primary key, but it is not created with not null column.is it possible to alter a column having null into not null..........

DB2 v8.2 and o/s windows 2002.

Any help..........


Thanks
Meena.s

i dont think so...
u hav to update rows having null to some value,
export,
create table with new definition,
create indexes and constraints,
import back

u have to take care that there are no duplicates for 'no'
regards,
Rahul Singh

Have a look at this previous thread Altering a Table Column with data from not null to null

Hey Wim,
frankly ,i avoid using altobj as very little details are available in infocenter which makes it even more difficult to understand.
i had gone through Serge article but still too hard to grasp(at least for me )
well i suppose altobj does all those steps in the background (export/create/import).
neways thanks a lot for help.

MEENA: if u want to avoid all these steps u can directly go to control center and alter table from null to not null and then create PK.

Rahul Singh

Rahul,

To be honest, I too feel the same towards the documentation and use of altobj. But it could be helpfull in certain situations. It's always good to have an extra joker in your sleeve, just in case...

Thanks for ur Reply.

Thanks Rahul.It works fine.

But internally it calls that system stored procedures it seems......


Thanks
Meena.s