IBM Mainframe Forum

Hi..

I have a Db2,I am adding a new column to it.Do I need tocompile my programs again even if I am not using that column in my programs.

Your question is so simple, I think you should do the research yourself. Doesn't take much. There are any number of ways to find out this answer. Even just thinking about it a bit more might get you there. You have a test environment? I rarely say this, but just try using a program that doesn't access the column. If the whole lot collapses you get a hint, if it doesn't you get a different hint. But get to a definitive answer. You must have a manual? It is in there, I'm sure.

Depends what the program does and how it does it
Properly coded with good site standards on how to access tables you can easily isolate applications from table changes - so avoiding the need to recompile
On the other hand if you get it wrong (simple) your code will crash and burn