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
- 8346 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 |
How do we specify index to include or not during bind process.
How to solved 818 error
4 Answers Keane India Ltd, Wipro,
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What is a collection?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
What is copy book?
What is the difference between drop table and delete table?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
how we will do null data selection in cobol-db2 program
What do you mean by commit and rollback?
how can i pull up a query which was previously stored in qmf
Which command is used to connect to a database in DB2 ? Give the Syntax.
COBOL 
