Entering Default value into a new table column without having the DEFAULT clause in table script. (4332458)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Entering Default value into a new table column without having the DEFAULT clause in table script.
Description

Entering a Default value into new column without DEFAULT clause in table. Is it possible to add a NOT NULL column to a table and
enter a default value into this new column, but without having added a DEFAULT-clause in the DDL of the table?
Resolution

WORKAROUND:
Add the new column in the insert statement with a default value.

STATUS:
Enhancement request CR #66148 has been submitted to Development for consideration in future release of Toad for DB2.
Defect ID

CR #66148

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title