What is the difference between CS and RR isolation levels?
Answer / s
CS - page or row locks are released as soon as the cursor
is moved to another row or page.
RR - page or row locks are held for all accessed rows,
qualifying or not atleast until the next commit point.
| Is This Answer Correct ? | 8 Yes | 2 No |
What is db2 bind?
How can you count the number of rows from a table tab?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
Where can you declare a cursor in a cobol-db2 program?
What is package versioning? Please give an example.
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
What is precompiler in db2?
What is rebind in db2?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
What is the clustering index in the db2 database?
What is plan in cobol db2?
What is a host variable?