i want to delete 20th million record how ?
Answers were Sorted based on User's Feedback
Answer / rajesh
Hope this will do.
delete from tbname where rowcount(*) = 200000 ;
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / sxion045
CREATE VIEW RR(A,B,X) AS
SELECT R.*, ROW_NUMBER()
FROM R;
DELETE FROM RR
WHERE X=20000000;
Is This Answer Correct ? | 2 Yes | 0 No |
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
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / magesh
delete from (select row_number() over() as COLUMN1 from
TABLE_OWNER.TABLE_NAME )
where COLUMN1=20000000;
Is This Answer Correct ? | 0 Yes | 1 No |
How do I add a column in db2?
What is a DB2 plan?
How do I import data from excel to db2?
What is a system catalog table in db2?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is meant by dclgen?
What do you need to do before you do EXPLAIN ?
How to design maps
What do you mean by storage group (stogroup)?
How can you count the number of rows from a table tab?
What will the FREE command do to a plan?