Alter column drop not null db2

Posted: Thu Nov 20, am. Hi, Please ignore my post. Posted: Thu Nov 20, pm. Yes alter can be used for this change. Posted: Fri Nov 21, am. Hello, Quote:. View previous topic :: :: View next topic.

Similar Topics. Adding a header when change data. Uploading from desktop, a CSV file, s The Overflow Blog. Podcast Making Agile work for data science.

Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Related Hot Network Questions.

Question feed. Stack Overflow works best with JavaScript enabled. What do you mean by change a column from null to not null? The only thing that would make sense is if you're trying to put a validation on the column in which they can not leave the column blank.

In which case, you're trying to add a check constraint. If that is the case, you need to look up the syntax for that. If that is not the case, I have no idea what you're trying to do. Rabbit, Thanks for the reply. Your initial guess is correct. Expand Select Wrap Line Numbers. Here's what I was able to find in the documentation.

JUKe 2. Did you ever determine how to do this? I am trying to do the same thing using db2 zos v9. Arshayub31 1. XF 1 Bit.

Post Reply. Alter Column Type.