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
How do you concatenate the firstname and lastname from emp table to give a complete name?
What are the various isolation levels possible?
How do I create a view in db2?
What is the use of value function?
What is db2 instance?
What is the latest version of ibm db2?
How do you find the maximum value in a column in db2?
How to restart a DB2 program?
What is a db2 table?
What is package in cobol db2?
Mention the definition of cobol in varchar field.
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 are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is dbrm? What it contains? When it will be created?
What is a db2 collection?