what is the use of cursors?

3 Answers   iGate,

---

What is coalesce in db2?

0 Answers  

---

How to fetch the last row from the table in SQL (db2)?

0 Answers  

---

What are some characteristics of columns that benefit from indexes?

1 Answers  

---

What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,

---

1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).

1 Answers  

---

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,

---

How to check last update on table in db2?

0 Answers  

---

What is a view? Why use it?

3 Answers  

---

Describe major components of db2?

0 Answers  

---

i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?

2 Answers   EDS,

---

What is correlated subquery?

1 Answers  

---