DB2: A calls B once sucessfull and second time when it
calls says curson is open why is it so?



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

Post New Answer

More DB2 Interview Questions

where can we use index and subscript ? with example ?

3 Answers   CTS,


How does coalesce work?

0 Answers  


How to create backup table in db2?

0 Answers  


How to design maps

1 Answers   Virtusa,


What is an alias?

3 Answers  






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   iGate,


can any one expalin check point with an example?

1 Answers  


what is the name of the default db2 catalog database?

3 Answers   IBM,


While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,


What is rct?

0 Answers  


What is a subselect? Is it different from a nested select?

1 Answers  


Mention some fields that are a part of sqlca.

0 Answers  


Categories