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 / 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
How do you simulate the explain of an embedded sql statement in spufi/qmf?
How to find the maximum value in a column in the db2 database?
What is cursor in dbms?
What is a db2 table?
How to find the number of rows in a db2 table?
What are packages in db2?
What is dpf in db2?
What is a storage group (stogroup)?
What is the maximum No of rows per page?
How to take backup of table in db2?
What is runstats db2?
What is ibm db2 connect?
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.
Mention the location where the output received from explain statement is stored.
How do I delete a table in database?