Setting Up Query Managers

Defining and Using Query Managers

You can define the following types of Query Managers:

personal Query Manager: Use a personal Query Manager to define the SAS or DB2 data that you want to query. If no Query Manager has been defined, then a personal SAS Query Manager is created the first time you enter the Query and Reporting Query window. Personal Query Managers also are called user Query Managers.
public Query Manager: Use a public Query Manager if you want to enable a group of users to have the same type of access to the same SAS data libraries or DB2 tables. A public Query Manager can be available either to all users (Master Query Manager) or to a group of users (Group Query Manager).
dynamic Query Manager: Use a dynamic Query Manager if you want your queries to always reflect the most current structure of the SAS or DB2 tables to which you have access in your SAS session. For example, if you add new tables (SAS tables) to your SAS data libraries or add new columns to your tables, these changes are automatically reflected by the dynamic Query Manager. Information about the structure of the tables is displayed more slowly when you use a dynamic Query Manager.
static Query Manager: Use a static Query Manager when you want to access information quickly about the structure of your SAS or DB2 tables. A static Query Manager provides fast access to the Query Manager tables. However, a static Query Manager requires that you manually update the Query Manager tables when the structure of the tables changes, for example, when new tables (SAS tables) are added to your SAS data libraries or when new columns are added to the tables. A static Query Manager is the default Query Manager.

You can combine the various types of Query Managers. For example, you can create a static, public SAS Query Manager or a dynamic, personal DB2 Query Manager. The following display shows an example of a setup for a user who has three Query Managers that give access to three SAS data libraries and two different DB2 subsystems.

Query Manager Examples

[Query Manager Examples]

This chapter describes how to set up two Query Managers. Not all possible types of Query Managers are described. The following table shows which Query Manager features are used in which examples. Each example is a complete description of the setup for a Query Manager.

Query Manager Examples
	Personal SAS Query Manager Example	Public SAS Query Manager Example
Master/Group Profile		X
Database SAS	X	X
Database DB2		X
Update tables using Update Query Manager	X	X
Update tables from Program Editor window or in batch		X
Tables' location specified by libref	X	X
Tables' location specified by physical file name		X
Static Query Manager	X	X
Dynamic Query Manager	X
Allow update of relations from Join window	X
Do not allow update of relations from Join window		X
Use Initiation Program		X
Use Termination Program		X
Use Generation Program		X
Use Query Manager profile		X

Top of Page