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 |
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
What is dbrm?
What can the SET option of the Repair Utility accomplish?
Describe what a storage group(STOGROUP) is?
what is datacom db?
Who uses db2?
What is a synonym ?
How do you Load a table ?? and what is Load replace ?
i have a db2 variable how do u declare tht into working storage section ?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is the syntax for FETCH in DB2 ?
What is the purpose of using commit?