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
- 5153 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
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
How to check last update on table in db2?
How can record locking be achieved in those DB2 versions which do not support it?
What is dbrm? When it will be created?
What is nvl in db2?
What is host variable in db2 cobol?
How does coalesce work?
What is bind in db2?
What is release/acquire in bind?
How to test SQL -911 error while developing COB-DB2 program
List some fields from sqlca?
How is a typical db2 batch pgm executed?
What is runstats db2?
What are types of indexes?
What is dbrm?
