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 the sqlcode -501

13161

---

Mention the various locks that are available in db2.

1041

---

Explain about open switch business continuity software?

1136

---

How to find schema of a table in db2?

1017

---

What is dbrm library?

1064

---

What are db2 tables?

1126

---

What is the physical storage length of timestamp data type?

1096

---

Can there be more than one cursor open for any program?

1169

---

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

1028

---

What is cascading rollback?

1215

---

Differentiate between cs and rr isolation levels? Where do you specify them?

1071

---

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1197

---

List out the three types of page locks that can be held.

1149

---

is it compulsory commitment control in journal?

2479

---

Are views updateable?

1163

---