Suppose if I need to update a column, how you do that using
cursor?
- 2 Answers
- 8541 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 the difference between primary key & unique index ?
Explain the function done by data manager?
what are the bind parameters?
what are stage one indexable predicates?
What is netezza database?
What does a deadlock mean in DB2?
What is the difference between cursor stability and repeatable read isolation levels?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
How to find the maximum value in a column in the db2 database?
Which are the db2 tools to protect integrity of the database?
What is the maximum length of sqlca?
COBOL 
