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

Can you use max on a char column?

0 Answers  


what is the differences between spufi and qmf and which is better?

4 Answers   Accenture, Cap Gemini,


What's the difference between DB2 active log and archive log? Thanks a lot...

2 Answers   IBM,


What is the difference between CS and RR isolation levels?

1 Answers  


What is sqlcode -922 ?

2 Answers  






What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  


What is CHECK PENDING ?

5 Answers  


What techniques will be used to avoid deadlock??

5 Answers   IBM, SUN,


Can All Users Have The Privilege To Use The SQL Statement Select (DML)?

1 Answers  


How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

5 Answers   Syntel,


How do I delete a table in database?

0 Answers  


What is the physical storage length of time data type?

0 Answers  


Categories