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?



Consider that a package is bound into 2 different collections and the PKLIST option specifies both..

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

Post New Answer

More DB2 Interview Questions

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,


Name some fields from SQLCA.

2 Answers  


Which catalog tables contain authorization information?

1 Answers  


What is dpf in db2?

0 Answers  


How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,


I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?

2 Answers  


What is a SELECT statement?

1 Answers  


What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?

1 Answers  


What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;

4 Answers   Accenture,


if i made sme changes in sub pgm wht r the things to be done for this ?

1 Answers   TCS,


Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,


Can you define an Index if the table size less than 10 PAGES?

1 Answers   IBM,


Categories