IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Alter COLUMN to allow NULLs


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
srj1957

New User


Joined: 15 Dec 2005
Posts: 72
Location: RALEIGH NC, USA

PostPosted: Fri Dec 28, 2007 8:26 pm
Reply with quote

We are using V8..
I'm needing to alter columns from NOT NULL to NULL... I've searched the web but am having difficulty finding solution ...mostly it says I must drop the table and re-create ... is this true icon_question.gif
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Sat Dec 29, 2007 5:20 am
Reply with quote

srj1957 wrote:
We are using V8..
I'm needing to alter columns from NOT NULL to NULL... I've searched the web but am having difficulty finding solution ...mostly it says I must drop the table and re-create ... is this true icon_question.gif


You can't do it. Unload the table to a flat file, delete & redefine it, then reload.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Replacing 'YYMMDD' with date, varying... SYNCSORT 3
No new posts How to load to DB2 with column level ... DB2 6
No new posts RC query -Time column CA Products 3
No new posts DROP & ALTER PARTITION-PBR DB2 0
No new posts first column truncated in search result IBM Tools 13
Search our Forums:

Back to Top