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 the sqlcode -501
what is db2 restart?
How do I import data from excel to db2?
Who uses db2?
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?
What is null in db2?
What is db2?
What is dclgen in db2?
How can you do the explain of a dynamic sql statement?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is the default page size of buffer pools?
What are types of indexes?
What are the contents of dclgen?
What do you mean by storage group (stogroup)?
What is a cursor in programming?