Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5169 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 |
What is a view? Why use it?
In terms of DB2 indexing, what is the root page?
What is a predicate?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
How do you filter out the rows retrieved from a Db2 table ?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
what is the use of bind parameter, Replace?
What is db2? Explain.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
how to take the back up of the DB2 table.
Generally if I want to select the names starting with c I need to use c% But how could I code to select the data which contains % as a part of data.
Can there be more than one cursor open for any program?
COBOL 
