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

alter column(from null to not null) in DB2 v8.x.x

P: n/a
As captioned question, i would like to how to alter the column from
null to not null?
Thanks

Mar 22 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
si*****@gmail.com wrote:
As captioned question, i would like to how to alter the column from
null to not null?
In V9:

ALTER TABLE ... ALTER COLUMN ... SET NOT NULL

V8 doesn't support this statement, so you would have to drop and re-create
the table. DB2 Control Center has some support for that.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Mar 22 '07 #2

P: n/a
On Thu, 22 Mar 2007 14:31:36 +0100, Knut Stolze <st****@de.ibm.com>
wrote:
>si*****@gmail.com wrote:
>As captioned question, i would like to how to alter the column from
null to not null?

In V9:

ALTER TABLE ... ALTER COLUMN ... SET NOT NULL

V8 doesn't support this statement, so you would have to drop and re-create
the table. DB2 Control Center has some support for that.
Of course, he could just ADD a CONSTRAINT manually CHECKing for NOT
NULL.

B.
Mar 22 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.