Answer / s

SYSIBM.SYSRELS

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

1 Answers  

---

What are the functions of Bind?

2 Answers   Amdocs, IBM,

---

How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,

---

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

0 Answers  

---

what is the difference between declaring the cursor in WS section and Procedure division?

1 Answers   HCL,

---

How do you stop a db2 database in linux?

0 Answers  

---

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

3 Answers   Infosys,

---

What is a correlated sub query?

2 Answers  

---

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers  

---

When do you specify the isolation level? How?

1 Answers  

---

How to find primary key of a table in db2?

0 Answers  

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  

---