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 |
What is a clustering index?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
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.
What is difference between isnull and coalesce?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
Define db2.
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
How to check sequence on a table in db2?
how do we solve soc 7 and soc4 ?
how to check the table is empty or not?
What does the CHECK Utility do ?
How can you compare table column after update and before update?