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
- 4316 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 |
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
Give the COBOL definition of a VARCHAR field.
What are the various locking levels available?
Before you give the explain statement, what are the prerogatives?
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
How to update more then one record using update?
What is cursor?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What is cloudant database?
is it possible to get -811 error when you use cursors. why?
Is db2 free?
How to get Top 10 Salaries from a Table
COBOL 
