Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 4 Answers
- 9001 Views
- Mphasis, I also Faced
- E-Mail Answers
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
Can we insert update delete in view?
Define db2 and its databases?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
What happens in bind step in a db2 program?
What is explain plan in db2?
What is database manager in db2?
Explain about mirror activator disk mirroring?
Explain the function of data manager.
What is the use of commit in db2?
What is db2 purescale?
Explain package in db2 and its advantages?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
What are the bind parameters ibm db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is a storage group (stogroup)?
