How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)

Answer Posted / s

If you like the cursor maintain the position even after the
commit, CURSOR is defined WITH HOLD.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a cursor in programming?

812


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

1894


What language is db2 written in?

784


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2900


What is the role of the data page in the db2 database?

781


What is the connection string to connect to the DB2 Database ?

847


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

826


Explain the function of data manager.

810


What is syscat in db2?

772


What is bind plan?

800


Explain correlated sub-queries.

768


How do I add a column to an existing table in db2?

779


Can one database have multiple instances?

794


Which components manage deadlocks in db2?

809


Which command is used to connect to a database in DB2 ? Give the Syntax.

830