by using cursors , we can access particular records from
the table based on some condition, i want to delete those
selected records, how can we write a query for this in the
program?
- 4 Answers
- 7520 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / satty
first declare cursor and select the records you wanted and
then use delete statement with where current of your cursor.
becoz it will help you to delete that particular record
which has been choosed.
if any thing wrong plz intimate
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How do you find the maximum value in a column in db2?
Which component is used to execute the sql statements?
What is innodb buffer pool?
What is a dbrm in db2?
Is ibm db2 free?
Why db2 is called db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How do you select a row using indexes in db2?
How to retrieve rows from a db2 table in embedded sql?
What is the difference between spufi and qmf?
How to find the number of rows in a db2 table?
What is buffer pool and list some of them?
What is the difference between cursor stability and repeatable read isolation levels?
What is the reason behind not using select * in embedded sql programs?
What do you mean by commit and rollback?
