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
- 8398 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 |
when does the SQL statement gets executed when you use cursor in the application programming ?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is null indicator in db2?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
How to restart a DB2 program?
what is the process of precompiler?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
What are the rules for db2 programming?
what are extents?
cursor with hold explain ?
What is the use of dclgen in db2?
What is coalesce in db2?
COBOL 
