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 difference between oracle and db2?

578


What is the physical storage length of time data type?

658


What is the physical storage length of date data type?

716


What is the use of db2?

574


What is ibm db2 client?

512






What is check constraint. Explain with example.

635


Explain in brief how does db2 determine what lock-size to use?

585


What types of tables are there in the db2 database?

543


Mention data types used in db2 ?

663


What is null indicator in cobol db2?

571


What is collection in db2 bind?

565


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2678


Which is faster delete or truncate?

665


What is explain in db2?

576


What is difference between alias and synonym in db2?

633