We can use concept of cursor to delete particular row. The row where the

i have a table like this :
Name ADDRESS
Toto 123 ...
Toto 456
ToTo 678

I would like to delete 2 last row...please tell me how to
delete its

Question Posted / suv

5 Answers
9482 Views
EDS, I also Faced
E-Mail Answers

Answer Posted / suv

We can use concept of cursor to delete particular row. The
row where the cursor is pointing will get deleted.

Please correct is wrong..

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the physical storage length of the data types date, time, and timestamp?

1142

How do you find the maximum value in a column in db2?

1155

Explain about rct in db2?

1166

How to create db2 table in mainframe?

1220

What do you mean by commit and rollback?

1090

What is phantom read in db2?

1227

What is the meaning concurrency in the db2 database?

1170

What is the use of commit in db2?

1144

How to rename a table in DB2 ?

1147

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3266

How to execute stored procedure in db2 command editor?

1104

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2117

What is the difference between dbm cfg and db cfg file in db2 ?

1594

What is package in db2 mainframe?

1040

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1543