Suppose if I need to update a column, how you do that using
cursor?
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 does db2 blu stand for?
How to design maps
What is the purpose of rollback and commit?
1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.
What does db2 stand for?
When would you prefer to use VARCHAR?
List out the data types available.
When is the access path determined for dynamic SQL?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Which component is responsible for processing sql statements and selecting access paths?
Define sqlca.