What is a collection?
Answers were Sorted based on User's Feedback
Answer / sadiq afroze
A user defined name that is the anchor for packages. It has
not physical existence. Main usage is to group packages.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mehdee
Collection is not an actual, physical database object.
Collection is a grouping of DB2 packages.
All packages reside in administrative units called
collections.
PLAN is an executable module containing the access path
logic to one or more DBRMs
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
collection is a group of packages.
package is collection of plan.
| Is This Answer Correct ? | 1 Yes | 5 No |
can we drop column from a table
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
is it possible to get -811 error when you use cursors. why?
What is dbrm?
What is meant by concurrency?
What do you mean by cursor?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
What is the syntax for FETCH in DB2 ?
Differentiate between cs and rr isolation levels? Where do you specify them?
Before you give the explain statement, what are the prerogatives?
Can we update view in db2?
what are bind concepts in db2 cobol?