Interested to Buy Any Domain ? << Click Here >> for more details...
What is a collection?
- 3 Answers
- 7051 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 |
What is dbrm? What it contains? When it will be created?
When the like statement is used?
Why db2 is called db2?
what is a plan and how do you refer the plan in the program?
What DB2 Catalog column tell you when an index needs table reorganized ?
I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country
what is the use of bind parameter, Replace?
What is a db2 table?
What is runstats and reorg in db2?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
what is different three logs in DB2?
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 .
COBOL 
