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

how 2 resolve the -311 sqlcode

1 Answers  


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

0 Answers  


in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,


Can you access the DB2 Directory table using SQL?

3 Answers  


What is a DB2 plan?

8 Answers  


How do I start db2 in windows?

0 Answers  


How can you display the current date & current time ?

7 Answers   Cap Gemini,


what is check point and restart Logic ? why do we go for that ??

2 Answers   CGI, UST, Xansa,


The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,


What is blu acceleration in db2?

0 Answers  


Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  


If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  


Categories