Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose if I need to update a column, how you do that using
cursor?
- 2 Answers
- 8317 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 cursor stability?
What will happen, while trying to close the closed cursor.
what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names
What is the difference between SYNONYM and ALIAS?
how can u understand the end of the table ?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
what is Static and dynamic linking
Could anyone clearly explain the diference between sub query and correlated sub query?
how do we solve soc 7 and soc4 ?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
How do you Load a table ?? and what is Load replace ?
What is difference between rollback and commit?
COBOL 
