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
- 7519 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 are bind concepts in db2 cobol?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is dbrm? What it contains?
How to restart a DB2 program?
How does db2 sample database connect?
What is database alias db2?
Which are the db2 tools to protect integrity of the database?
What is the default page size of buffer pools?
What is db2 look?
How to find schema of a table in db2?
Why cursor is used in db2?
What is schema in db2?
When the like statement is used?
What is consistency token in db2?
List down the types of triggers in the db2 database?
