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 / vaneesh khurana
Hi Satty
Can you please let us know what command you will use for
delete.
Vaneesh
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is netezza database?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How can you quickly find out the # of rows updated after an update statement?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is ibm db2 connect?
Where can you declare a cursor in a cobol-db2 program?
How to create db2 table in mainframe?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How to test SQL -911 error while developing COB-DB2 program
What are the full forms of spufi and dclgen and why are they used?
What is db2 purescale?
How do I add a column to an existing table in db2?
Is db2 a database?
How do we specify index to include or not during bind process.