5 rows are inserted to a DB2 Table. Next 3 of those are
updated, then a rollback is issued. What would happen when
the rollback is issued?
Answers were Sorted based on User's Feedback
Answer / rashmi
The 5 inserted records will not be there in the table.
Becouse rollback is happening before the commit(Untill
unless you commit it, the changes will not reflect in the
table).
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / guest
The 5 rows inserted will be not be present in the table.
| Is This Answer Correct ? | 5 Yes | 0 No |
What is DCLGEN ?
How do you run JCL in cobol program
Is ibm db2 free?
Mention and explain the contention situations caused by locks?
Explain db2.
What Utility is used to migrate DB2 from one release to the next?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
What is -904 sql code? How to resolve it?
Mention the different locking levels that are available in db2.
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
Once you create a view, where would information about the view be stored?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance