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
Where do you specify them?
How does db2 sample database connect?
What is dclgen (declaration generator)?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Name the lockable units in DB2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is db2 bind process?
What is cursor with hold option in db2?
How to run db2 command in windows?
What is the max length of sqlca?
What are the contents of a dclmgen?
What is coalesce in db2?
can we view the access paths created by dbrm ? how ? thx
Explain db2.
What is syscat in db2?