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
- 9151 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
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is the difference between spufi and qmf?
What is page size in db2?
Can we insert update delete in view?
What is the default page size of buffer pools?
What is db2 command?
Are view updateable?
What does db2 stand for?
What is db2 bind?
How to execute stored procedure in db2 command editor?
Is db2 a mainframe database?
What are host variables in db2?
Highlight all the advantages that are attached to a package.
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?
How many databases are there?
