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
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
Are view updateable?
What is view db2?
How does db2 sample database connect?
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.
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What is a storage group (stogroup)?
What is table space in db2?
How can we read records for specific member in CL? AND rpg?
What is image copy in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
How do I delete a table in db2?
What is package in cobol db2?
Explain what are the various isolation levels possible?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is the cobol picture clause of the db2 data types date, time, timestamp?