Do we need to recompile a program after changing the DCLGEN

V S Amarendra Reddy · Active User Joined: 13 Sep 2006 Posts: 216 Location: USA

Hi,

My requirement is a field of a table going to be increased from 2 to 3.

So now do I need to recompile all the programs which are using this changed table??

or

Is it enough to recompile only the programs which are using the changed column of the table??

Please clarify me

ravi17s · New User Joined: 15 Aug 2003 Posts: 57

You only need to recompile and Rebind the Program using the new columns.

If the table being altered is being dropped and re-created with the new columns. U may need to bind all the packages refering the Table.

Help-Me-Out · New User Joined: 09 Dec 2006 Posts: 56 Location: Pune

It is advisable that you recompile and rebind all which uses this table to avoid the future compilcations....