Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 6342 Views
- I also Faced
- E-Mail Answers
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 |
can you use symbolic parameters in JOB?
How do you eliminate duplicate values in db2?
What will the FREE command do to a plan?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
How does coalesce work?
What is the purpose of using commit?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Mention the location where the output received from explain statement is stored.
what is differnece between DROP TABLE & DELETE TABLE .
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
COBOL 
