Glossary

Key rules for safe column addition:

The column should allow NULLs (no NOT NULL constraint) or have a DEFAULT value. - Adding a column with NOT NULL and no DEFAULT will fail on LUW if the table contains data. On z/OS, the behavior depends on the DB2 version and compatibility settings. - The column is added at the end of the row — you c

Learn More

Related Terms