Answer / rajesh

Hope this will do.

delete from tbname where rowcount(*) = 200000 ;

Answer / sxion045

CREATE VIEW RR(A,B,X) AS
SELECT R.*, ROW_NUMBER()
FROM R;
DELETE FROM RR
WHERE X=20000000;

Answer / 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

Answer / magesh

delete from (select row_number() over() as COLUMN1 from
TABLE_OWNER.TABLE_NAME )
where COLUMN1=20000000;

What is reorg and runstats in db2?

0 Answers  

---

What is auditing?

2 Answers  

---

What is collection in db2 bind?

0 Answers  

---

How does DB2 determine what lock-size to use?

2 Answers  

---

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

---

how 2 resolve the -311 sqlcode

1 Answers  

---

wht are the restrictions for union ?

2 Answers   CTS,

---

Can one database have multiple instances?

0 Answers  

---

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

---

What is EXPLAIN?

1 Answers  

---

What is reorg in DB2

3 Answers   Virtusa,

---

what is the Foreign key? explain?

2 Answers  

---