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 what a plan is?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
what is the maximum number of tables that can be joined ?
How would one remove old reorg information from the DB2 catalog?
what is the process of precompiler?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is host variable in db2 cobol?
When do you specify the isolation level?
What is Skeleton cursor table (SKCT)?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What is a host variable?