Answer / s

SYSIBM.SYSRELS

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 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 DCLGEN ?

2 Answers  

---

Explain in brief how does db2 determine what lock-size to use?

0 Answers  

---

what happend with out using Commit,when closing cursor and program?

5 Answers   CSC,

---

---

How to fetch the uncommited data from table ?

1 Answers   JPMorgan Chase,

---

When do you specify the isolation level?

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,

---

What is cobol db2?

0 Answers  

---

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

---

What is JOIN and different types of JOIN.

2 Answers   IBM,

---

How Plan is created while executing the query using SPUFI?

3 Answers  

---