Adding new columns to DB2 table

[mfsavvy]

Hi ,

My question is "IS it necessary to precomp,bind all the application programs using table X " if I add a new column to table X ?

[sweeperb]

not necessary unless you will use the new variables or did a SELECT * FROM. However, I strongly recommend that it be done. It may not seem like much now, but your structures will not match the data, if you change the program at a later date, long after people have forgotten you changed it, it may cause some consternation.

[mfsavvy]

New column is defined as CHAR (34) NOT NULL WITH DEFAULT.
Does this new column affect any existing inserts ??

[petwir]

It should not harm existing INSERTS.

But don't just take our word for it. You should do some test runs of one or two of these programs against a test set of DB2 tables to prove it to yourself before risking your production environment.