I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

---

Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?

4 Answers  

---

How can you display the current date & current time ?

1 Answers   Cap Gemini,

---

What does DML stand for and what are some examples of it?

3 Answers   IBM,

---

What is check constraint. Explain with example.

0 Answers  

---

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  

---

What is the use of commit in db2?

0 Answers  

---

How to restart a DB2 program?

0 Answers   Cognizant,

---

What does a deadlock mean in DB2?

0 Answers  

---

Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle

1 Answers   Infosys,

---

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 the STOSPACE Utility used for?

1 Answers  

---