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  

---

How do you find the maximum value in a column in db2?

0 Answers  

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

What does the CHECK Utility do ?

1 Answers  

---

What is performance tuning db2?

0 Answers  

---

---

What is an asychronous write?

1 Answers  

---

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?

1 Answers   HeadStrong,

---

What kind of database is db2?

0 Answers  

---

What is meant by isolation level?

3 Answers  

---

How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,

---

how to fetch multiple records without using cursor

14 Answers   HCL,

---

Do we need cursor for Count(*)?

4 Answers   iGate,

---