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?
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
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is runstats db2?
How do we specify index to include or not during bind process.
What is buffer pool and list some of them?
What is schema in db2?
Explain about rct in db2?
How to take backup of table in db2?
What is the use of db2?
On which levels locks can be applied?
How to access db2 tables in mainframe?
What do you mean by cursor?
What is rebind in db2?
What is isolation level in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is a db2 table?