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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Hi Satty
Can you please let us know what command you will use for
delete.
Vaneesh
Is This Answer Correct ? | 0 Yes | 0 No |
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 |
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is the clustering index in the db2 database?
What is a DB2 bind?
What does db2 blu stand for?
Where would you find information about the type of database authority held by the user?
What is reorg in DB2
what is a corelated subquerry?
How do you filter out the rows retrieved from a Db2 table ?
how do you resolve -805?
What is database reorganization?
How to define the data items to receive the fetch items for the SQL?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?