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|
How do I delete a table in db2?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How can record locking be achieved in those DB2 versions which do not support it?
What is collection in db2 bind?
Which command is used to remove all rows from a table?
Is the primary key a clustered index?
What is cascading rollback?
What are the bind parameters ibm db2?
What is ibm db2 connect?
What is runstats and reorg in db2?
Which isolation level provides highest data integrity?
What is lock escalation in db2?
How and when does the db2 enforces the unique key?
What is package in db2 mainframe?
What is phantom read in db2?