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 cursor with hold option in db2?

832


What are host variables in db2?

829


What is coalesce in db2?

881


What is a db2 cursor?

821


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

879


What are the benefits of using the db2 database?

906


Which are the db2 tools to protect integrity of the database?

918


can all users have the privilage to use the sql statement select * (dml)?

872


Can one database have multiple instances?

823


What is the difference between spufi and qmf?

836


List out the data types available.

933


What is copy pending status in db2?

884


How to check table size in db2 sap?

799


What is view db2?

865


What is bind package and plan in db2?

817