i have table agdet i want first 5 maximum commission which query will you write for this thanks in advance

3 Answers  

---

What is db2 command?

0 Answers  

---

What is dbrm? What it contains?

0 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

---

What is tablespace?

3 Answers  

---

how do you resolve -805?

3 Answers   HCL,

---

What is the picture clause of the null indicator variable?

6 Answers  

---

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

0 Answers   Broadridge,

---

What are the functions in DB2?

3 Answers   Satyam,

---

what is cursor stability?

2 Answers   IBM,

---

what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,

---