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 to execute stored procedures?

622


Name the various locking levels available?

637


What is a system catalog table in db2?

589


What is null indicator in db2?

604


What is the difference between dbm cfg and db cfg file in db2 ?

1007






How can deadlocks be resolved?

542


What are foreign keys in db2?

616


Explain about dbrm.

609


How to fetch the last row from the table in SQL (db2)?

1041


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10777


List down the types of triggers in the db2 database?

592


What are the full forms of spufi and dclgen and why are they used?

657


How can we read records for specific member in CL? AND rpg?

234


What is the purpose of using commit?

618


What is a cursor in programming?

596