Answer / s

Isolation level determines how long the page or row locks
will be held.

Answer / manidhan

ISOLATION LEVEL - Level of Isolation between two
transactions that want the same resource.

Answer / srinivas chennareddy

Isolation level will let you know,how soon the acquired
lock will be released.

What do you mean by between and in? Is between inclusive of specified range values?

0 Answers  

---

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

0 Answers  

---

What is image copy?

1 Answers   Virtusa,

---

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 Answers  

---

What do you do to keep the cursor from closing after a commit?

1 Answers  

---

List out the three types of page locks that can be held.

0 Answers  

---

4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.

3 Answers   Wipro,

---

What is a view? Why use it?

3 Answers  

---

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

2 Answers  

---

How can you count the number of rows from a table tab?

0 Answers  

---

i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its

5 Answers   EDS,

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---