Article - CS213835

"SQL0109" error on Alter Table statement when adding column, specifying NOT NULL without a DEFAULT in Implementer

Modified: 17-Jan-2020   


Applies To

  • Implementer 11.0 to 12.1

Description

  • Added column to existing table, specifying NOT NULL clause but do not have DEFAULT
  • Alter table fails with SQL0109 Position ## NOT NULL clause not allowed.
    • Alter table may be auto-generated by Implementer to accomplish task
This is a printer-friendly version of Article 213835 and may be out of date. For the latest version click CS213835