What happens to a cursor after a commit?

Answer Posted / azharuddinsyed

If the cursor is defined with "WITH HOLD" option, it will NOT closed even after the commit operation, else cursor will be closed.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

898


Define declaration generator (dclgen).

859


What is a dbrm in db2?

732


Explain about rct.

847


What is the information associated with sysibm.syslinks table?

862






i want to maintain uniqueness on pdf without make lf??????????

1876


What action db2 takes when a program aborts in the middle of a transaction?

849


What is the picture clause of null indicator variable?

858


Define predicate?

843


What is drop table?

759


What is node in db2?

787


What is universal database?

813


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

763


What is a plan and package in db2?

819


What is cursor with hold option in db2?

787