Interested to Buy Any Domain ? << Click Here >> for more details...
If I have a view which is a join of two or more tables, can
this view be updatable?
- 3 Answers
- 7305 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
If view has join that time view can not be updatable.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / mahesh vasudevan
One can not make update operation on a view that has a join
from more than two or more tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
how can we retrieve the 100 records of the file ?
What is the role of union all and union
What is the clustering index in the db2 database?
What is the function of buffer manager?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is database alias db2?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What is view db2?
What is difference between *omit and *nopass?
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.
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
COBOL 
