Suppose if I need to update a column, how you do that using
cursor?
Answer Posted / bobby
continuation of previous answer,
after cursor declaration, open the cursor and fetch the cursor. When the condition for update is satisified isue EXEC SQL UPDATE CURRENT OF.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the difference between bind and rebind in db2?
What is a db2 schema?
What is the use of db2?
If I have a view which is a join of two or more tables, can this view be updateable?
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
What does db2 stand for?
Comment whether the cursor is closed during commit or not.
What is host variable in db2 cobol?
What is difference between isnull and coalesce?
What is commit in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is database reorganization?
How do I import data from excel to db2?
Explain how can you do the explain of a dynamic sql statement?
Differentiate between cs and rr isolation levels? Where do you specify them?