suppose in my table 10 rows are there , i want to update odd
rows salary as 90000 ? how u do it ? any one help me ? what
do we use here cursor-fetch or normal sql ?
Answer Posted / saurabh
It can be achieved using the scroll able cursor along with the Relative option while updating the queue.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is a buffer in memory?
What is plan in cobol db2?
What is the physical storage length of time data type?
What is an instance in db2?
What is dclgen (declaration generator)?
Explain package in db2 and its advantages?
What are the various data types available in db2?
What is database alias db2?
Explain in brief how does db2 determine what lock-size to use?
What does db2 mean?
What is difference between isnull and coalesce?
What is table space in db2?
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?
what is a corelated subquerry?