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
- 8171 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 would you print the output of an SQL statement from SPUFI?
What are the different types of base tables?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
How do you run JCL in cobol program
What are some characteristics of columns that benefit from indexes?
What is package versioning? Please give an example.
What is coalesce in db2?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
How can you display the current date & current time ?
What are the benefits of using the db2 database?
What is the difference between nvl and coalesce?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
COBOL 
