Interested to Buy Any Domain ? << Click Here >> for more details...
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 ?
- 2 Answers
- 8436 Views
- iGate, I also Faced
- E-Mail Answers
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's The Percentage Free Space ?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
What is runstats utility in db2?
What are the benefits of using the db2 database?
What is the purpose of the QUIESE Utility?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
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?
Can we install 2 different versions of Db2 on same mainframe?
How can you display the current date & current time ?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is the purpose of rollback and commit?
Why do we bind in db2?
COBOL 
