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 dbm cfg and db cfg file in db2 ?
What is db2?
What language is db2 written in?
What are db2 tables?
What do you mean by storage group (stogroup)?
What is consistency token in db2?
What are db2 objects?
What is cobol db2?
What is the default page size of buffer pools?
How can you classify the locks in db2?
List out the data types available.
What is the information associated with sysibm.syslinks table?
How to execute stored procedure in db2 command editor?
How do I create a view in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time