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 ?
Answers were Sorted based on User's Feedback
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 |
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 ? | 8 Yes | 17 No |
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
Return code 100 means?
What is dynamic SQL?
How do you filter out the rows retrieved from a Db2 table ?
What do the initials DDL and DML stand for and what is their meaning?
What types of tables are there in the db2 database?
How Plan is created while executing the query using SPUFI?
What is ibm db2 database?
db2 restart logic ?
When do you specify the isolation level?
What is a DB2 bind?
what is sql abend code -801,-802?