What is a collection?
- 3 Answers
- 5523 Views
- I also Faced
- E-Mail Answers
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 |
For Read Stability locks are not applicable for phantoms, What is Phantoms?
Write a query to extract first 5 characters of a name in the column Stud_Name?
What is commit in db2?
Can I use LOCK TABLE on a view?
Can a Db2 table data be retrived through JCL?
What is DYNSLT keyword? How do you perform selection using DYNSLT
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 2
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
how to identify the pseudo conversation by seeing the program
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
What is host variable in db2 cobol?
What do you mean by rollback?
COBOL 
