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

Are view updateable?

627


What is catalog database in db2?

642


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1626


Explain the contention situations caused by locks?

589


What r the comman abends in db2, jcl and cobol???????

1818






What is dbrm? What it contains?

679


What is the difference between db2 and oracle?

673


What is drop table?

582


On which levels locks can be applied?

655


What is database manager in db2?

549


What is lock escalation in db2?

574


Can you tell me how can you find out the # of rows updated after an update statement?

608


What are bind parameters in db2?

611


How to take backup of table in db2?

599


Where can you declare a cursor in a cobol-db2 program?

602