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
- 8295 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 |
how do u update the faltfile into db2 table ?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Can one database have multiple instances?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
Is db2 relational database?
What is db2 and what is the use of db2 optimizer?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token
Return code 100 means?
What is a Cartesian product?
What's The Error Code For Unique Index Voilation?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
COBOL 
