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 |
how 2 resolve the -311 sqlcode
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
Can you access the DB2 Directory table using SQL?
What is a DB2 plan?
How do I start db2 in windows?
How can you display the current date & current time ?
what is check point and restart Logic ? why do we go for that ??
The only place of VSAM KSDS in DB2 is?
What is blu acceleration in db2?
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?
If I have a view which is a join of two or more tables, can this view be updatable?