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 are the various locks available?

5 Answers   CTS,

---

what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'

10 Answers   Amdocs,

---

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

0 Answers  

---

Mention and explain the contention situations caused by locks?

1 Answers  

---

Why db2 is called db2?

0 Answers  

---

What is a correlated sub query?

2 Answers  

---

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,

---

What is copy pending and check pending in db2?

0 Answers  

---

what are bind concepts in db2 cobol?

0 Answers  

---

On the create tablespace, what does the CLOSE parameter do?

1 Answers  

---

what is Static and dynamic linking

1 Answers   Virtusa,

---

What do you need to do before you do EXPLAIN ?

1 Answers  

---