Differentiate between cs and rr isolation levels? Where do you specify them?
No Answer is Posted For this Question
Be the First to Post Answer
Mention some fields that are a part of sqlca.
What is isolation level in db2?
What is the difference between static and dynamic SQL?
Can we update view in db2?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
What are the disadvantages of using VARCHAR?
What are the three DB2 date and time data types and their associated functions?
What is coalesce in db2?
Mention the various locks that are available in db2.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?