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
How does coalesce work?
What is the use of runstats in db2?
Which is faster delete or truncate?
How to connect to db2 database from windows command line?
How to find the number of rows in db2 tables?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the physical storage length of date data type?
What is db2 purescale?
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 does db2 stand for?
How is deadlock resolved?
What are db2 objects?
What is the purpose of rollback and commit?
What is difference between isnull and coalesce?
Explain the benefits you can get from mainframe connect?