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
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How would the varchar column remarks defined?
What does reorg do in db2?
What do you mean by rollback?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What language is db2 written in?
What is a bind card?
Mention the downsides of page level lock.
What is a buffer in memory?
What is dbrm library?
What is the connection string to connect to the DB2 Database ?
How do I add a column to an existing table in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is cursor stability in db2?
What parameters are used to control the free space in DB2?