When do you specify the isolation level? How?



When do you specify the isolation level? How?..

Answer / s

Isolation level can be specified at BIND time using the
ISOLATION parameter or in the SQL statement using the WITH
clause

WITH UR;

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is a clustering index?

2 Answers  


How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 Answers  


This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  


What is difference between isnull and coalesce?

0 Answers  


How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers  






Define db2.

0 Answers  


Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  


How to check sequence on a table in db2?

0 Answers  


how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,


how to check the table is empty or not?

3 Answers   IBM,


What does the CHECK Utility do ?

1 Answers  


How can you compare table column after update and before update?

5 Answers   Satyam,


Categories