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
What is a buffer in memory?
What is db2 plan table?
How do you find the maximum value in a column in db2?
How can you count the number of rows from a table tab?
What is the difference between nvl and coalesce?
What is deadlock in db2?
What is the difference between spufi and qmf?
If I have a view which is a join of two or more tables, can this view be updateable?
What are the two types of logging in the db2 database? Explain them.
What is ibm db2 connect?
What is db2? Explain.
Is db2 free?
How to create db2 table in mainframe?
How do I change the column size in db2?
What is runstats db2?