Interested to Buy Any Domain ? << Click Here >> for more details...
How to update more then one record using update?
- 5 Answers
- 11479 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / selvam a
Update a table using a symbolic cursor:
UPDATE WHERE CURRENT OF limits the scope of DB2 updates to
one row at a time, specifically the row your cursor is
positioned on.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the prerogatives?
Which isolation level provides highest data integrity?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is the role of data manager in the db2 database?
What is reorg and runstats in db2?
What is dbrm in db2 database?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How do you concatenate the firstname and lastname from emp table to give a complete name?
If I have a view which is a join of two or more tables, can this view be updateable?
Where can you declare a cursor in a cobol-db2 program?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is the physical storage length of timestamp data type?
How do I add a column to an existing table in db2?
Which component is responsible for processing sql statements and selecting access paths?
