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 is null in db2?

0 Answers  

---

What does an outer join do?

1 Answers   CTS,

---

When Can you be sure that a query will return only one row?

4 Answers   IBM,

---

What is sqlca’s maximum length?

0 Answers  

---

What is a system catalog table in db2?

0 Answers  

---

What is the difference between oracle and db2?

0 Answers  

---

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers   Perot Systems,

---

How to compare data between two tables in db2?

0 Answers  

---

How will you delete duplicate records from a table?

7 Answers   Google,

---

How to take backup of table in db2?

0 Answers  

---

Explain about mirror activator disk mirroring?

0 Answers  

---