If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,


My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  


Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?

3 Answers  


Explain the use of the WHERE clause?

1 Answers  


What is catalog database in db2?

0 Answers  






Is ibm db2 open source?

0 Answers  


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,


Highlight all the advantages that are attached to a package.

0 Answers  


How to view db2 table structure?

0 Answers  


How can the duplicate values be eliminated from db2 select?

0 Answers  


Can we delete records from view?

0 Answers  


For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  


Categories