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?
Answer / 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 |
What do you mean by storage group (stogroup)?
wht happens if we close cursor with cursor with hold option?
What is a page in db2?
What is coalesce in db2?
My SQL is not performing well. Describe how will you fine tune it?
What is tablespace?
How do I add a column to a table in db2?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.
Explain the function of data manager.
Outputs of explain are with matchcols = 0. What does this signify?
Explain the contention situations caused by locks?
How to fetch the uncommited data from table ?