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 |
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records
Name some fields from SQLCA.
Which catalog tables contain authorization information?
What is dpf in db2?
How to resolve -407 sql code in DB2?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
What is a SELECT statement?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
if i made sme changes in sub pgm wht r the things to be done for this ?
Q3. How will you fetch duplicate values from a DB2 table?
Can you define an Index if the table size less than 10 PAGES?