Added columns not present in Insert Query!

Hritam · New User Joined: 27 Jun 2005 Posts: 36 Location: India

Hi,

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 ?

Thanks

dick scherrer · Posted: Tue Aug 21, 2007 1:15 am Post subject:

Hello,

Hritam · New User Joined: 27 Jun 2005 Posts: 36 Location: India

Thanks d!

dick scherrer · Posted: Wed Aug 22, 2007 2:28 am Post subject:

You're welcome

stodolas · Posted: Wed Aug 22, 2007 2:37 am Post subject:

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.

dbzTHEdinosauer · Posted: Wed Aug 22, 2007 3:13 am Post subject:

Steve,

won't NOT NULL WITH DEFAULT take care of that problem? As long as the OP is ok with 5 columns with zeros or spaces in the 'unmentioned' columns.

stodolas · Posted: Wed Aug 22, 2007 5:43 am Post subject:

I stand corrected. I'm not a DBA, I only play with them and forgot about the default on columns even though I deal with it every day.

Craq Giegerich · Posted: Wed Aug 22, 2007 6:11 am Post subject:

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.