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 |
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
how will you retrieve first record in table
What is the latest version of ibm db2?
Q3. How will you fetch duplicate values from a DB2 table?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is an alias and how does it differ from a synonym?
What is an instance database?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is Reorg Recovery? when will you run it?
What is the use of dclgen in db2?
What is dbrm in db2 database?
What is a result table?