My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,

---

how can we find nth max salary from A table

5 Answers   IBM,

---

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

1 Answers   Hewitt,

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

Which command is used to remove all rows from a table?

0 Answers  

---

How can you compare table column after update and before update?

5 Answers   Satyam,

---

How to find the number of rows in db2 tables?

0 Answers  

---

Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  

---

Describe major components of db2?

0 Answers  

---

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  

---

What do you mean by cursor?

0 Answers  

---

how can u nderstand the sql stmts executed successfully or not ?

1 Answers   TCS,

---