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 new columns should be made part of the view,
the view needs to be regenerated.

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 bind package and plan in db2?

595


Is db2 a database?

574


What is query_cache_limit?

545


Which isolation level provides highest data integrity?

599


Is ibm db2 open source?

586






How will you return the number of records in table?

518


What is blu acceleration in db2?

608


What is the use of db2?

586


Explain the function done by data manager?

857


What is coalesce in db2?

682


What action db2 takes when a program aborts in the middle of a transaction?

659


What db2 400?

679


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

660


What r the comman abends in db2, jcl and cobol???????

1820


What is reorg?

619