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
- 8539 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 is database alias db2?
db2 restart logic ?
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
How do I delete a column in db2?
What is null value in db2?
What is syscat in db2?
can i code union in cobol-db2 pgm ?
Which transaction use a command thread ?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What do you need to do before you do EXPLAIN?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
COBOL 
