Update a column to null in db2

Pls help. Follow Post Reply. Baski wrote: Hi, I am a bit new to db2, and I am unable to find a proper alter table command syntax where I can remove a not null constraint on a column. For DB2 v8 you would have to recreate the table.

Experience Linux. Please note that this only works with DB2 v9. This discussion thread is closed Start new discussion. Cannot change column name. NET Framework. DB2 Database. Visual Basic. Primary Key column show null in DataGrid. MySQL Database. Microsoft SQL Server. Mobile Development.

Connect and share knowledge within a single location that is structured and easy to search. I'm using DB2 version I have a table with a timestamp for updates defined for me as follows in the Create Table statement :. On initial load of the data to this table, I want to set the value of this column to NULL for all rows, but I have not been successful.

I know I can get around this by just not specifying the column name and value, but I'd really like to know why this won't work. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 8 years, 4 months ago. Active 5 years, 5 months ago. Viewed 9k times.

Improve this question. Chucky 7 7 silver badges 14 14 bronze badges. Brian Brian 1 1 gold badge 7 7 silver badges 22 22 bronze badges. Add a comment. Active Oldest Votes. First, are you sure that col3 in the destination table is allowed to accept NULL values? Improve this answer.