Answer / hari143

no

select 100 records from million records ?

2 Answers   Verizon,

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

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?

0 Answers   HeadStrong,

---

What does the CHECK Utility do ?

1 Answers  

---

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

---

---

how to resolve -811 sqlcode .give clear explaination

3 Answers   IBM,

---

Which components manage deadlocks in db2?

0 Answers  

---

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

1 Answers   Danske,

---

How can you display the current date & current time ?

1 Answers   Cap Gemini,

---

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

---

What are union and union all?

0 Answers  

---

What is a buffer pool?

2 Answers  

---