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
- 5014 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the use of predicate?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is load replace in db2?
How connect db2 database to datastage?
What is bufferpool in db2?
can all users have the privilage to use the sql statement select * (dml)?
How to rename a table in DB2 ?
What are the various isolation levels possible?
What are the different types of base tables?
What is the maximum length of sqlca?
What is db2 bind?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What are db2 objects?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
