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 |
How do I start db2 in windows?
What does db2 plan contain?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the difference between db2 and oracle?
What is the command used by TSO users to invoke DB2?
What is a precompiler?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
wt is view ? wht r the restrictions for view ?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
Define db2.
Define db2 and its databases?