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

Answer Posted / ss

To remain cursor open after commit statement execution

Is This Answer Correct ?    33 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What os does db2 run on?

574


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2379


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

604


How can we retrieve the total number of records in RPG & CLLE?

198


What is the default page size of buffer pools?

650






Why do chiropractors use drop table?

662


define clustering index.

618


Why do we bind in db2?

632


What is multi row fetch in db2?

610


Which command is used to remove all rows from a table?

553


On which levels locks can be applied?

659


what is the responsibility of the construction superintendent

1664


Explain db2.

620


What do you mean by rollback?

572


What is a collection in db2?

584