For update of a row in cursors, when do we move value into host variable in co

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 / sudha2811

3 Answers
8820 Views
iGate, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it be..

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

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it be..

Answer / santhoshabbula

Since your talking about update , that will come after we fetch the fields from table so we Move the new value into the host variable after FETCH and immediately before the UPDATE ... WHERE CURRENT OF cursor statement.

Is This Answer Correct ?

0 Yes

0 No

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it be..

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

9 Yes

17 No

Post New Answer