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
- 8532 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 to find the number of rows in a db2 table?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
What is the picture clause of null indicator variable?
What are the Isolation levels possible ?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
Is db2 a mainframe?
How to create backup table in db2?
How is a typical DB2 batch program executed ?
What is the function of the Data Manager?
The only place of VSAM KSDS in DB2 is?
What is package versioning? Please give an example.
What is -904 sql code? How to resolve it?
COBOL 
