Posted: Thu Jul 17, 2003 2:28 am Post subject: recompile COBOL program if changing table structure?
Dear all,
Suppose that at the first time, I had field A, B, C in table TEST_1. Then I had already compiled and bound COBOL program to this table. After that, somehow, I change the structure of table TEST_1 to be field A,B,D,C. I'm wondering that if I have to recompile and rebind the progam to table TEST_1? If I have to do so, what should I do if I have many ten of programs referring to this recontrcted table?
If you are not referencing any of the new columns of a table, there is nothing you have to do manually. With the first execution of your program after structure modifications DB2 does an automatic REBIND by itself.
You get problems if you are issuing INSERT statements for a table and this table has new columns with "not null, no defaults". Then, of course, you have to change the code.
By the way: If you are changing the structure of a table shurely ALL using programs need at least a brief examination.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
