The query in a cursor in executed only when the cursor is opened. Thus you

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 ?

Question Posted / tarun

Answer Posted / tarun

The query in a cursor in executed only when the cursor is opened. Thus you have to move the values in the host variables before opening the cursor.

Is This Answer Correct ?

8 Yes

17 No

Please Help Members By Posting Answers For Below Questions

What is bind and rebind in db2?

646

What are host variables in db2?

624

How do I add a column to an existing table in db2?

590

Explain various types of locks in db2?

689

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

608

Mention the definition of cobol in varchar field.

688

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10760

What are the contents of a dclmgen?

628

What is the syntax for FETCH in DB2 ?

673

What are the full forms of spufi and dclgen and why are they used?

654

Why cursor is used in db2?

572

What is a page in db2?

610

What is a db2 package?

597

What is drop table?

582

What is the default page size of buffer pools?

644