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
How can the duplicate values be eliminated from db2 select?
What is the latest version of ibm db2?
What is the maximum number of columns in a db2 table?
What is collection in db2 bind?
What is dbrm in db2 database?
What is difference between isnull and coalesce?
Explain the function of data manager.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How do I import a csv file into db2?
can all users have the privilage to use the sql statement select * (dml)?
What is a db2 collection?
What action db2 takes when a program aborts in the middle of a transaction?
What is db2 catalog database?
What is the maximum length of sqlca?
Outputs of explain are with matchcols = 0. What does this signify?