How do you leave the cursor open after issuing a COMMIT?
(for DB2 2.3 or above only)
Answer Posted / a.roselin
CURSOR WITH HOLD Option
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain db2.
What is explain plan in db2?
What are the contents of a dclmgen?
How do we specify index to include or not during bind process.
What are concurrency issues?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Can we delete records from view?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is an instance database?
What is a db2 tablespace?
How many databases are there?
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 rct?
What is dbrm? When it will be created?
How to check sequence on a table in db2?