Suppose if I need to update a column, how you do that using
cursor?
- 2 Answers
- 6607 Views
- Verizon, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sandy
EXEC SQL DECLARE X CURSOR FOR
SELECT * FROM ABC
FOR UPDATE OF <COLUMN> ==>If we know the column we would
like to update.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is bind plan?
What happens to a cursor after a commit?
How can you find out the # of rows updated after an update statement?
What action db2 takes when a program aborts in the middle of a transaction?
What is query for your birthday date should be in hours,minute and seconds format?
Explain about dbrm.
Can you tell me how can you find out the # of rows updated after an update statement?
What is alias in db2?
What is the syntax for creating a table in the db2 database?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What are the four lockable units for DB2?
What is db2?
COBOL 
