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
- 4613 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 host variable in db2 cobol?
What is meant by concurrency?
how to unload different table data into different gdg files/ vsam files.
What do you mean by cursor?
What is access path in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
How does one remove entries from the SCT02 table?
what are the SQL codes u freequently got?
What is query for your birthday date should be in hours,minute and seconds format?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is an alias and how does it differ from a synonym?
COBOL 
