Answer / sai prakash

It is a default isolation level. It puts a lock on the data that has been fetched, so that the retrieved data can be updated or deleted.

Answer / siris

CURSOR STABILITY(CS):-
**it is row level locking...
**An Exclusive lick acquired on that row,the row to be
update....
**The lock is released on that row the control moves to the
next updatable row...

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

---

What is a view? Why use it?

3 Answers  

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

What is with ur in db2?

0 Answers  

---

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,

---

Why might full image copies be faster to implement than an incremental image copy?

4 Answers  

---

How do u achieve record level locking in DB2 versions when record level locking is not allowed?

2 Answers   IBM,

---

Is it possible to create an Instance in DB2 using DB2 Control Center ?

0 Answers   MCN Solutions,

---

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  

---

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,

---