What is drop table?

0 Answers  

---

How can you find out the # of rows updated after an update statement?

0 Answers  

---

I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?

4 Answers  

---

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  

---

What is db2 look?

0 Answers  

---

select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?

2 Answers  

---

difference between group clause and order clause

1 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  

---

What is blu acceleration in db2?

0 Answers  

---

What is node in db2?

0 Answers  

---

What is a bind card?

0 Answers  

---