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 |
explain about index with examples
What is a cursor?
What happens to the PLAN if index used by it is dropped?
what is db2 restart?
Which transaction use a command thread ?
how to u check the query is executing or not ?where will u check for sqlcode ?
wt is view ? wht r the restrictions for view ?
Is db2 free?
What does an outer join do?
Which are the db2 tools to protect integrity of the database?
what is the name of the default db2 catalog database?
how to copy the host variables from ps file into cobol program other than include statement