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
- 5060 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 |
What is the purpose of the DSNC transaction ?
Mention the location where the output received from explain statement is stored.
How can you quickly find out the number of rows updated after an update statement?
What is the purpose of the WHENEVER statement?
What is QUIESCE?
What is a collection?
What does an outer join do?
Mention data types used in db2 ?
What is an instance in db2?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
Explain about cursor stability?
What is dpf in db2?
COBOL 
