By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,746 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

Altering column's default in db2 V8

P: 2
I'd like to change default of several columns from NULL to NOT NULL without dropping tables.

From SQL reference it seams possible, but I can't suceed
Can you help me please

Monica07
Oct 17 '07 #1
Share this Question
Share on Google+
1 Reply


docdiesel
Expert 100+
P: 297
Hi,

don't have my DB2 reference at hand right now, but as far as I remember a "SET INTEGRITY FOR my.table OFF" before the ALTER TABLE should help. After that you'll have to turn on INTEGRITY again. This should be something like "SET INTEGRITY FOR my.table IMMEDIATE CHECKED FORCE GENERATED".

Regards, Bernd
Oct 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.