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
Is ibm db2 open source?
What is database manager in db2?
What do you mean by commit and rollback?
What is concurrency?
What is multi row fetch in db2?
What is the difference between plan and package in db2?
Mention the different locking levels that are available in db2.
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What is the syntax for FETCH in DB2 ?
What is sqlca’s maximum length?
what is utility for parm lib
How to create db2 table in mainframe?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is view db2?
Who uses db2?