Answer Posted / shammi

SELECT *
FROM (select * from employee ORDER BY salary desc) employee2
WHERE rownum <= 10
ORDER BY rownum;

correct me if am wrong

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2598

---

What is the connection string to connect to the DB2 Database ?

1176

---

What is ibm db2 client?

1008

---

How to find primary key of a table in db2?

1127

---

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1542

---

What is blu acceleration in db2?

1132

---

How do I delete a table in database?

1079

---

Define sqlca.

1174

---

What is plan in cobol db2?

1206

---

What is collection in db2 bind?

1064

---

Give a brief description of db2 isolation levels?

1141

---

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3266

---

How to find the number of rows in a db2 table?

1158

---

What is dpf in db2?

1170

---

What is dclgen (declaration generator)?

1119

---