Answer / mohammadanis

DB2 Isolation is locking technqiue for tables.It can given
while binding the programs. There are several Isolation
levels are there,

1 CS(cursor stability)
2 RR(repeatable read)
3 RS(READ Stability)
4 UR(Uncommited read also known as Dirty read

Answer / bala

Isolation by its name explains the level by which two or more concurrent transactions are isolated from each other to maintain the data integrity in the database.

for example transaction A and transaction B are concurrent transactions, then it defines if A can read/update the data being modified by B or not and vice versa.

These Isolation levels will be used based on the business logic.

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

---

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,

---

What is -904 sql code? How to resolve it?

3 Answers  

---

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

0 Answers  

---

what is REORG? what is the use?

4 Answers  

---

Is db2 a programming language?

0 Answers  

---

What is Call attach facility? How does it work?

1 Answers   Syntel,

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  

---

What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?

2 Answers  

---

What else is there in the PLAN apart from the access path?

1 Answers  

---

what is the use of cursors?

3 Answers   iGate,

---