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

i want to delete 20th million record how ?

Question Posted / sxion045

4 Answers
10772 Views
IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the contention situations caused by locks?

1014

Define data page.

1015

What is iseries database?

991

What is db2 instance?

1018

How does a cursor work?

931

How do I import a csv file into db2?

938

What is the syntax for creating a table in the db2 database?

1060

What is the use of predicate?

985

Explain about cursor stability?

985

What is a db2 table?

958

What is load replace in db2?

938

What is the use of db2 optimizer?

1042

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1660

What is bufferpool in db2?

987

Where can you declare a cursor in a cobol-db2 program?

996