what is a collection?
Answers were Sorted based on User's Feedback
Answer / s
Collection is a logical grouping of packages, eg grouping
by application, Grouping by environment like test,
production. It is not a physical object.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / prasad
Hierarchy
Plan
Collection of collections is Plan
Collection
Collection of packages is Collection
Package
Collection of items is Package
Is This Answer Correct ? | 0 Yes | 2 No |
How do you concatenate the firstname and lastname from emp table to give a complete name?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What is meant by isolation level?
What os does db2 run on?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
Name some fields from SQLCA.
What is the maximum length of sqlca?
What else is there in the PLAN apart from the access path?
Can SQL statements/queries be included in a copybook?
What is temporal table in db2?
How can you quickly find out the number of rows updated after an update statement?
What are the prerogatives?