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 |
List out the data types available.
What are union and union all?
What is the SQL Communications Area and what are some of its key fields?
how we will do null data selection in cobol-db2 program
how to resolve -811 error. give clear explination
What is cursor stability in db2?
What is check constraint. Explain with example.
When is the skeleton cursor table created?
i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance
Why do we use cursor?
What should be specified along with a cursor in order to continue updating process after commit?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?