Answer Posted / ratheesh nellikkal

Hi All,

I don't think RR and ROWCOUNT works in DB2 for LUW.
So you could go for another option.
Row_number() Over() function you can use for this puspose.

Eg.
delete from (
select row_number() over() as row_num from
TEST.TABLE_TEST )
where row_num=20000000;

where TEST is my schema name and
TABLE_TEST is my test table.

Cheers Guys.
Ratheesh Nellikkal

Why db2 is called db2?

1053

---

Which isolation level provides highest data integrity?

1131

---

What is a system catalog table in db2?

1196

---

Explain about rct.

1094

---

Mention the various locks that are available in db2.

1050

---

Explain about dbrm.

1054

---

How would you find out the total number of rows in a db2 table?

1059

---

Define declaration generator (dclgen).

1123

---

Why do we use cursor?

1107

---

what is diffrence b/w file-aid tool and file-aid utility???

4906

---

How can we read records for specific member in CL? AND rpg?

707

---

What is the role of the data page in the db2 database?

1032

---

What is db2 purescale?

1013

---

What does a deadlock mean in DB2?

1175

---

What is view db2?

1085

---