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

0 Answers  

---

How can you count the number of rows from a table tab?

0 Answers  

---

How would one remove old reorg information from the DB2 catalog?

2 Answers  

---

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,

---

What is db2 stogroup?

0 Answers  

---

What is host variable in db2 cobol?

0 Answers  

---

Can we update view in db2?

0 Answers  

---

What are foreign keys in db2?

0 Answers  

---

query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop

2 Answers   IBM,

---

What is declare cursor?

0 Answers  

---