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 |
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
What is a storage group (stogroup)?
how can i pull up a query which was previously stored in qmf
Q3. How will you fetch duplicate values from a DB2 table?
In a single table,How to retrieve a employee-id of an employee who works in more than one department?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
Can we able to find all the Table names under a Particular Plan?
How to create a table using embedded sql?
What is buffer pool in the db2 database?
How does DB2 use multiple table indexes?
What action db2 takes when a program aborts in the middle of a transaction?