Interested to Buy Any Domain ? << Click Here >> for more details...
When one binds a PACKAGE ( of a plan ) what package
information is stored and where it is stored?
- 3 Answers
- 8387 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
Package is a single bound DBRM which contains the SQL
statements of a single application program or subroutine.
The package is a executable internal code that contains
access paths computed by the optimizer.
Bound packages are stored in SPT01 tablespace of the
DSNDB01 directory.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is a db2 package?
How does a cursor work?
What is a storage group (stogroup)?
What is sqlca?
What is syscat in db2?
Which component is responsible for db2 startup and shutdown?
How many types of page locks can be held in db2?
What is the maximum size of varchar data type in db2?
What is declare cursor?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What are the full forms of spufi and dclgen and why are they used?
What is a page in db2?
What are foreign keys in db2?
How does coalesce work?
