If the base table underlying a view is restructured, eg.
attributes are added, does the application code accessing
the view need to be redone?
- 2 Answers
- 4506 Views
- I also Faced
- E-Mail Answers
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 |
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Who uses db2?
what is difference between random and sequence file access
Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.
What is clone table?
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
What is package in cobol db2?
what is Static and dynamic linking
What is db2 instance?
What is the role of schema in the db2 database?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What does the sqlcode of -818 pertain to?
COBOL 
