For update of a row in cursors, when do we move value into
host variable in cobol progrm? is it before open or before
fetch ?

Answer Posted / azharuddinsyed

in Open, the sql query you have coded in declare cursor will be executed.
in Fetch, the table column values will be moved to corresponding host variables.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is db2 catalog database?

778


How do I connect my db2 database to ibm?

782


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

845


How can you do the explain of a dynamic sql statement?

815


What is difference between rollback and commit?

853


How would the varchar column remarks defined?

828


what is the role of the cursor in db2?

808


Can we update view in db2?

749


What is copy pending status in db2?

846


What is database alias db2?

817


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

887


What is cobol db2?

729


What is concurrency?

895


What is runstats db2?

751


Is db2 a database?

725