We have altered a Db2 table and added 5 more columns in the last.
There is an existing insert query which inserts into this table but does not have these new 5 columns.
This insert query is in CICS screen.
Will this insert query in CICS screen work fine without the new 5 columns ?
Joined: 13 Jun 2007 Posts: 632 Location: Wisconsin
If the fields allow NULL values it will be fine, but all those extra 5 columns will contain NULL. If they are defined to not allow NULL your insert will fail.
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
When you add new columns to an existing table the new columns either have to be null or not null with default. An insert that worked before the columns were added will work afterwards.