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

Is schema the same as database?

864


What is the use of value function?

881


What is the physical storage length of the data types date, time, and timestamp?

898


Are view updateable?

837


How would you find out the total number of rows in a db2 table?

814


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

857


What is ibm db2 used for?

855


Define db2.

911


What types of tables are there in the db2 database?

832


How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2021


What is difference between alias and synonym in db2?

886


How and when does the db2 enforces the unique key?

879


Discuss about db2 bind?

898


How to check table size in db2 sap?

812


What is copy pending and check pending in db2?

780