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

How to find the number of rows in db2 tables?

1129

---

What is catalog database in db2?

1218

---

If I have a view which is a join of two or more tables, can this view be updateable?

1185

---

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1315

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2440

---

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2774

---

What is the difference between bind and rebind in db2?

1512

---

What is the physical storage length of date data type?

1308

---

What is runstats db2?

1076

---

What is a buffer in memory?

1110

---

What types of tables are there in the db2 database?

1101

---

What is schema in db2?

1081

---

What do you mean by storage group (stogroup)?

1083

---

What are the bind parameters ibm db2?

1102

---

How can the duplicate values be eliminated from db2 select?

1159

---