recompile/relink question in regard to DB2 Views

[mrfelson]

I'm a government employee and I was given the the challenging task of writing an analysis paper on the introduction of DB2 views into our environment(DB2,VB, PowerBuilder, BiQuery). Currently accesses are against the physical DB2 tables. When changes are made to a table it is a standard to recompile/relink all COBOL programs that access the table.
I don't know much about the relinking/recompiling process or why it is done.

First Question: If a column is added to a table what king of changes or recompiling/relinking will the cobol program need.

Second Quetion: If a column is added to a base table and not included in the view do cobol programs need to be recompiled/relinked? and Why?

Thanks
Ed

 

[gregsimpson]

Ed,

I think you need to read up on things like binds and dbrmlibs etc. I suspect from this and your other posts that you don't always need to recompile and link. Your site probably are when often they could get away with a bind. My guess is the binding to the database is part of your recompile and links steps.

Cheers
Greg