What happens to a cursor after a commit?
Answers were Sorted based on User's Feedback
Answer / angoca
The commit will close the cursor if this last was not
declared with the 'with hold' option.
Is This Answer Correct ? | 14 Yes | 0 No |
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 |
Where is the access path logic created by the DB2 Optimizer stored?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....
Is db2 a programming language?
WHAT IS MEANT BY COMMIT COMMAND?
What is performance tuning db2?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
What is concurrency?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
What is the physical storage length of date data type?
How do I import a csv file into db2?
What is rct?
What is the use of dclgen in db2?