What is the significance of the CURSOR WITH HOLD clause in
a cursor declaration?

Answer Posted / mainframe virumbi

The answers given above is correct only. Adding those, we
cant execute sql statements other than select, after commit
is encountered.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you find the maximum value in a column in db2?

838


What is the use of runstats in db2?

785


What is dclgen in db2?

879


Explain the benefits you can get from mainframe connect?

724


What is package in cobol db2?

868


What is explain plan in db2?

773


What is multi row fetch in db2?

774


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1845


How do I delete a table in database?

779


What is difference between isnull and coalesce?

796


What are db2 objects?

823


What is the use of db2?

787


What is the reason behind not using select * in embedded sql programs?

837


Where can you declare a cursor in a cobol-db2 program?

774


What are types of indexes?

773