Suppose if I need to update a column, how you do that using
cursor?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the connection string to connect to the DB2 Database ?

701


What is blu acceleration in db2?

697


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

725


How do I create a view in db2?

692


What is role in db2?

691






What is cobol db2?

645


What is query_cache_limit?

629


How do I start db2 in windows?

657


How do I change the column size in db2?

709


What is the picture clause of null indicator variable?

772


How to rename a table in DB2 ?

711


what is the sqlcode -501

11707


Where do you specify them?

770


What is consistency token in db2?

749


What are the contents of dclgen?

744