DB2: A calls B once sucessfull and second time when it
calls says curson is open why is it so?
Answer / sunil
while declearing the cursor in working-storage
section 'with hold' option is used due that's why cursor
remains open while next processing
| Is This Answer Correct ? | 8 Yes | 0 No |
assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it
Explain what a plan is?
What is DCLGEN ?
What is package in cobol db2?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
Which component is responsible for processing sql statements and selecting access paths?
Explain about mirror activator disk mirroring?
How to retrieve rows from a db2 table in embedded sql?
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
what is copy pending and check pending ?
What is the picture clause of the null indicator variable?
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.