If I have a view which is a join of two or more tables, can
this view be updatable?
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 |
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
What is null indicator in cobol db2?
How can record locking be achieved in those DB2 versions which do not support it?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
What are the advantages of using a PACKAGE?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
How to run db2 command in windows?
What is the purpose of using commit?
What is the command used by TSO users to invoke DB2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is buffrpool? Where we use it ?
How many clustering indexes can be defined for a table?