You did not state what operating system DB2 version 7 runs on.
As long as there is no 'select *' used (all columns are explicitly stated) in the view, then you do not have to recompile or rebind the program. Never use select * in an application program or in a view definition.
AFAIK, you don't need to recompile or rebind your program when you have a view with "select *" either. The problem is, the view doesn't get modified (the new columns are 'invisible' for the view) and this is sometimes confusing.
Just another cause not to use "select *" by defining views.
Rodney, I think you are correct. However, the problem is that plans/packages do get rebound for other reasons sometimes, and when that happens, there is potential for problems when select * is used in the view.
For example, a DBA might want to drop and recreate an index (which will force an automatic or explicit rebind of any plans/packages that use that index), or use rebind with explain yes to populate the explain tables, etc. So to guard against these rebinds, the program would need to be changed to add the new column, recompiled, and then do a bind replace (assuming that select * was in the view).