What is the command used by TSO users to invoke DB2?

2 Answers   IBM,

---

How can you get the number of rows impacted by the last executed query?

1 Answers  

---

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

---

i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  

---

Discuss about db2 bind?

0 Answers  

---

Why do we need reorg in db2?

0 Answers  

---

What is the difference between using bind () and rebind () methods of naming class?

0 Answers  

---

what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.

2 Answers   Syntel,

---

What is a DBRM, PLAN ?

3 Answers  

---

in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.

2 Answers   iGate,

---

What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  

---

What are the uses of db2 optimizer?

0 Answers  

---