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.

How do you find the maximum value in a column in db2?

0 Answers  

---

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers   IBM,

---

What are the 2 sqlcodes that are returned?

0 Answers  

---

What is subquery ?

6 Answers  

---

What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,

---

db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2

9 Answers   TCS,

---

How do I change the column size in db2?

0 Answers  

---

What is a db2 schema?

0 Answers  

---

Explain various types of locks in db2?

0 Answers  

---

What is IMAGECOPY ?

6 Answers  

---

I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.

8 Answers  

---

what is commit & rollback? When and where is used while compiling a cobol-db2 program?

2 Answers  

---