66) What are the advantages of using a PACKAGE?
1. Avoid having to bind a large number of DBRM members into a plan
2. Avoid cost of a large bind
3. Avoid the entire transaction being unavailable during bind and automatic
rebind of a plan
4. Minimize fallback complexities if changes result in an error.
67) What is a collection?
a user defined name that is the anchor for packages. It has not physical
existence. Main usage is to group packages.
In SPUFI suppose you want to select max. of 1000 rows , but the select
returns only 200 rows.
68) What are the 2 sqlcodes that are returned? –
100 ( for successful completion of the query ), 0 (for successful COMMIT if
AUTOCOMMIT is set to Yes).
69) How would you print the output of an SQL statement from SPUFI? –
Print the output dataset.
70) How do you pull up a query which was previously saved in QMF ? –
??
|