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

What is a Foreign Key?

1078

---

Explain package in db2 and its advantages?

1190

---

What happens in bind step in a db2 program?

958

---

What is meant by union and union all?

987

---

What is the difference between bind and rebind in db2?

1428

---

What does reorg do in db2?

1018

---

Define sqlca.

1093

---

What is data manager?

1031

---

How to find the maximum value in a column in the db2 database?

1061

---

Explain the function of data manager.

1031

---

How can you quickly find out the # of rows updated after an update statement?

1025

---

Explain about dbrm.

1030

---

What is precompiler in db2?

997

---

What is drop table?

999

---

What is the max length of sqlca?

1206

---