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 / narayana reddy

delete current(cursor) from table

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a dbrm in db2?

580


Are views updateable?

647


How do I connect my db2 database to ibm?

604


What is check constraint in db2?

611


How to execute stored procedure in db2 command editor?

532






What do you mean by between and in? Is between inclusive of specified range values?

670


What is an instance in db2?

567


What is null value in db2?

567


How does a cursor work?

559


How do you select a row using indexes in db2?

647


How to resolve deadlock issue

17991


What is catalog database in db2?

646


Mention some fields that are a part of sqlca.

603


define clustering index.

620


What is difference between alias and synonym in db2?

646