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

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

Please Help Members By Posting Answers For Below Questions

What are the contents of a dclmgen?

1176

What is lock escalation in db2?

1083

How does db2 sample database connect?

1087

Describe major components of db2?

1145

Explain various types of locks in db2?

1207

What kind of database is db2?

1085

Define declaration generator (dclgen).

1172

Why cursor is used in db2?

1088

How to execute stored procedures?

1175

Explain the benefits you can get from mainframe connect?

1017

What is the syntax for FETCH in DB2 ?

1267

What do you mean by cursor?

1032

Can you tell me how can you find out the # of rows updated after an update statement?

1147

How can we retrieve the total number of records in RPG & CLLE?

707

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

3010