If the base table underlying a view is restructured, eg.
attributes are added, does the application code accessing
the view need to be redone?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / s
No, unless the application pgm needs to take advantage of
the new columns.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the purpose of using commit?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
Is db2 relational database?
What are foreign keys?
What will the COMMIT accomplish?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
what is the use of cursors?
What is meant by explain?
What's The Error Code For Unique Index Voilation?
What is SPUFI?
What is meant by a unit of recovery?
Why do we need reorg in db2?