If the base table underlying a view is restructured, eg.
attributes are added, does the application code accessing
the view need to be redone?

Answer Posted / s

No, unless the application pgm needs to take advantage of
the new columns.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between using bind () and rebind () methods of naming class?

806


Explain correlated sub-queries.

593


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2290


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3126


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1812






Can you tell me how can you find out the # of rows updated after an update statement?

621


What do you mean by cursor?

594


Explain about rct.

656


Is db2 relational database?

576


run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

3799


Why do chiropractors use drop table?

672


Why db2 is called db2?

601


What are the various isolation levels possible?

657


What is the function of logging in the db2 database?

648


What is copy pending status in db2?

644