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
- 5087 Views
- I also Faced
- E-Mail Answers
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 |
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
What does CURRENTDATA option in bind indicate
How to resolve -407 sql code in DB2?
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.
what is dynamic cursor?gives syntax for this?
How do I add a column to a table in db2?
What are the various data types available in db2?
Where is the access path logic created by the DB2 Optimizer stored?
Explain what a plan is?
What's The Percentage Free Space ?
What is difference between rollback and commit?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
COBOL 
