Interested to Buy Any Domain ? << Click Here >> for more details...
Consider that a package is bound into 2 different
collections and the PKLIST option specifies both the
collections. If the collection id is not specified in the
program while executing the SQL query, then when the DB2
system will search the package list, which collection will
it pick up or will it give an error/abend?
- 1 Answers
- 5098 Views
- I also Faced
- E-Mail Answers
Answer Posted / mani
Generally when the search is done the order in which the
collection id is specified in the list would be taken for
priority.
You can use the special register CURRENT PACKAGE PATH or
CURRENT PACKAGESET (if CURRENT PACKAGE PATH is not set) to
specify the collections that are to be used for package
resolution.
The CURRENT PACKAGESET special register contains the name of
a single collection, and the CURRENT PACKAGE PATH special
register contains a list of collection names.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Describe major components of db2?
List down the data types in the db2 database.
What is a db2 schema?
is it compulsory commitment control in journal?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is copy pending status in db2?
What is view db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How do you stop a db2 database in linux?
What is the role of schema in the db2 database?
What is the maximum No of rows per page?
Define db2.
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is netezza database?
What is null in db2?
