DB2 for z/OS: Answering Some Questions About Adding and Dropping Table Columns This is an off-site link.  Please review our Terms of Service for additional information.

(Robert Catterall) From the very beginning, you've been able to add a column to an existing DB2 for z/OS table by way of the SQL statement ALTER TABLE with the ADD COLUMN option. In fact, relative ease of logical database design modification had a lot to do with DB2 becoming a very widely used DBMS.

Read this article...

comments powered by Disqus