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
List some fields from sqlca?
What is query_cache_limit?
Is ibm db2 free?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
When the like statement is used?
How does cobol compile db2 program?
What is the difference between nvl and coalesce?
What is dbrm? When it will be created?
What is db2 instance?
What is coalesce in db2?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is the maximum No of rows per page?
What is the physical storage length of timestamp data type?
What does db2 mean?
What db2 400?