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
- 9047 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / vaneesh khurana
By the way, why to select a signle row using cursor then
delete, if you want to delete all the row mentioned in the
cursor search creteria, simply write a SQL query mentioning
delete where (matching search condition).
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the clustering index in the db2 database?
What is db2 optimizer?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is the result of open cursor statement?
What is dclgen in db2?
What is lock escalation in db2?
What is role in db2?
How and when does the db2 enforces the unique key?
How to connect to db2 database from windows command line?
What are db2 tables?
What is bind plan?
What are the two types of logging in the db2 database? Explain them.
What is query_cache_limit?
What is the maximum size of a char data type in db2?
What is host variable in db2 cobol?
