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 |
i want to maintain uniqueness on pdf without make lf??????????
What do the initials DDL and DML stand for and what is their meaning?
How do I change the column size in db2?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
How do you do the EXPLAIN of a dynamic SQL statement?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
what is the process of precompiler?
How to define the a field which accepts value till 99999.99 in db2
What happens in bind step in a db2 program?
What is a predicate?
How do I add a column in db2?
How to define the data items to receive the fetch items for the SQL?