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 |
What is the usage of open cursor command?
What are foreign keys?
cobol-db2 runjcl please?
Can we declare DB2 HOST variable in COBOL COPY book?
What is bufferpool in db2?
Is DECLARE TABLE in DCLGEN necessary? Why it used?
What is the database descriptor?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
What db2 400?
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
How will fetch last 5 rows from table in db2