Managing Your Query Library Table

One of the functions of a CA Dataquery Administrator is to maintain the CA Dataquery Query Library Table.

We recommend that you follow a regular backup schedule of the Query Library Table. You can use the BACKUP function of CA Datacom/DB Utility (DBUTLTY), or one of the other system backup functions. (See the CA Datacom/DB DBUTLTY Reference Guide for details.) Maintenance involves the following tasks:

Editing queries of other users
Deleting queries
Maintaining extended definitions for queries

Each task is discussed in this chapter.

QRYGRPS=NO

If the System Option Table parameter QRYGRPS=NO, the Query Library Table is not partitioned at the group level. This means that a user can:

Access any public query or dialog
Update any public query or dialog for which he is the author
Access his own private queries and dialogs regardless of the group levels that are assigned to him as a user or to the queries or dialogs

QRYGRPS=YES

If QRYGRPS=YES, group level access authorization partitioning of the Query Library Table is in effect. A user can access only those queries or dialogs that have matching group levels. The user cannot update any public queries or dialogs unless he has LIBRARY authorization.

Group level assignments limit the scope of queries to which the LIBRARY authorization extends. If the group level assignments do not match the Administrator's group level assignments, the Administrator cannot access the query. If the Administrator has no assigned groups, then his access to the query library is unlimited. Query group level assignments apply to both DQL Mode and SQL Mode (see Assigning Group Levels).