36.
Advantages of using a PACKAGE?
- It is used to avoid having to bind a large number of DBRM members into a plan
- Used to avoid cost of a large bind
- Also avoid the entire transaction being unavailable during bind and automatic rebind of a plan
- And Minimize fallback complexities if changes result in an error.
37.
What is a collection?
Collection is a user defined name that is the anchor for packages. It has not physical existence, and its Mainly used to group packages. In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows.
38.
What are the two sqlcodes that are returned?
100 ( for successful completion of the query ), 0 (for successful COMMIT if AUTOCOMMIT is set to Yes).
39.
When will you choose to run RUNSTATS?.
After a load, or after mass updates, inserts, deletes, or after REORG.
40.
What does it mean if the null indicator has -1, 0, -2?
-1 : the field is null
0 : the field is not null
-2 : the field value is truncated
|
|
||||||||||||||||||||||||||||
