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 sqlca?
What does db2 blu stand for?
What is ibm db2 connect?
What is null value in db2?
What is a page in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
How do you find the maximum value in a column in db2?
What is package in db2 mainframe?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the physical storage length of timestamp data type?
Can we update view in db2?
What do you mean by cursor?
How is deadlock resolved?
Which command is used to connect to a database in DB2 ? Give the Syntax.
what is diffrence b/w file-aid tool and file-aid utility???