Can we delete records from view?
- 1 Answers
- 1052 Views
- I also Faced
- E-Mail Answers
Answer / Vikas Kumar Jain
No, you cannot delete data directly from a view in DB2. To delete the underlying data, you must first query the base table(s) that the view is based on.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can you find out the # of rows updated after an update statement?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
how 2 resolve the -311 sqlcode
What is cloudant database?
pls tell me abt the normalization five types....
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What is nvl in db2?
what is difference between Static call and Dynamic call? How does it function?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is the physical storage length of time data type?
How can you compare table column after update and before update?
What is meant by isolation level?
COBOL 
