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
- 4994 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 are the prerogatives?
what is a corelated subquerry?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
In terms of DB2 indexing, what is the root page?
What do the initials DDL and DML stand for and what is their meaning?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
Can we delete records from view?
What is dbrm? What it contains? When it will be created?
What is CHECK PENDING ?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
What is the SQL Communications Area and what are some of its key fields?
Define predicate?
COBOL 
