Is binding required when program does not refer a newly added column

2 posts / 0 new
Last post
Anonymous
Is binding required when program does not refer a newly added column

There are few tables in the system and a column is added to one of these tables. There is a COBDB2 program which accesses this table but is not referring to the newly added column, do we need to bind this program to make sure it runs properly or binding is not required in this case.

I wish to be clear when the bind would be required.

-if the program is accessing the table. 

-if the program is accessing the newly added column. 

-or it depends on the position of the the newly added column.

I know I may be sounding very confusing, but if you could answer this for me, it will certainly help me.

"; ; ; ;
Anonymous
You need not bind the program

You need not bind the program if you are not using the new field. If your program uses 'SELECT * FROM table1', which is not a good practice, then you have to bind it.

Log in or register to post comments
Sponsored Listing