Previous Topic: Accessing the Online Administrative FunctionsNext Topic: Administrative Commands


Administrative Menu

To access administrative functions, sign on to CA Dataquery and press Enter after reading the bulletin board (if displayed). When CA Dataquery displays the Main Menu, select the ADMINISTRATION option, or enter ADMIN on the Command line (see Administrative Commands). CA Dataquery displays the administrative tasks assigned to you.

The following panel shows all the administrative functions that are available to CA Dataquery Administrators:

Administrative Menu (DQKH0)

=> ------------------------------------------------------------------------DQKH0 DATAQUERY: ADMINISTRATIVE MENU ---------------------------------------------------------------------------- ENTER DESIRED OPTION NUMBER ===> __ 1. PROFILE - Display and update user profile 2. CONDITIONS - List create and maintain conditions 3. RESTRICTIONS - List create and maintain restrictions 4. PRINTER CONTROL - Request control functions for a network printer 5. JCL - List and maintain batch query JCL 6. DIAGNOSTICS - Produce storage dumps 7. LANGUAGE - Translate DATAQUERY text to another language 8. USERS - List and maintain DATAQUERY users 9. SETS - List and maintain saved sets 10. LIBRARY - Maintain query library member attributes 11. SECURITY CONTROL - Table and column security authorization ----------------------------------------------------------------------------- <PF1> HELP <PF2> RETURN

Administrative Functions

The following is a brief explanation of each administrative function:

PROFILE

Display or update your profile. CA Dataquery allows a user to modify personal profile option defaults for the CA Dataquery online and batch features, primary and secondary language selections, and network printing options. Associate users do not have this privilege unless given the authority on the System Option Table. Some profile options default to values specified at the time the user is added to CA Dataquery or the privileges and authorizations are updated by a CA Dataquery Administrator. Other profile options default to values from the System Option Table.

CONDITIONS

(DQL Mode only) Create, delete, view, or edit a condition. A condition (when assigned to a restriction) allows a user or group of users access to some, but not all, of the rows in a table. You name the condition, identify the table and state the condition. For example, the condition might restrict access to all COMPANY records containing a value of 15 in the column for sales ID and a value of DALLAS in the CITY column.

RESTRICTIONS

(DQL Mode only) Create, delete, view, or edit a restriction. A restriction consists of one or more conditions applied to data access for a user or a group.

PRINTER CONTROL

Display a directory of outstanding network print requests. It allows a request to be canceled (flushed), stopped, or restarted from the point that it was stopped or from the beginning of the print request.

JCL

Create, delete, view, or edit JCL and JCL procs. (JCL procs members are JCL members that have variables. This guide discusses variables and procedure members in Creating a JCL PROC for Online Submission.)

DIAGNOSTICS

Display the CA Dataquery Request Table or request a storage dump in the form of a transaction dump or a module dump to assist CA Support in solving problems. For instructions about contacting CA Support, see the CA Dataquery Message Reference Guide. You can also display Compound Boolean Selection statistics. You choose where (terminal ID) and when the dump is to be turned on or off.

LANGUAGE

Translate and display CA Dataquery panels, program literals, and vocabulary terms to another language, or customize them to suit your site's needs. You also use this function to create messages to be placed on the CA Dataquery bulletin board.

USERS

Add, delete, view, and update users as well as list active users, users' profiles, and send messages to individual users. You can maintain a user's name, password, accounting code, group level, authorization for administrative functions and override system defaults. You can modify any user's profile. A CA Dataquery Administrator who is authorized to perform the USERS function, can assign user signons for new users to CA Dataquery or change a user's signon characteristics as discussed previously. As a CA Dataquery Administrator, you cannot delete yourself or turn off your user maintenance authorization.

The USERS authorization is the key to all other authorizations and should be carefully controlled.

SETS

(DQL Mode only) View, delete, and use saved found sets. Anyone (except the associate user) who runs a query can save the resulting collection of data as a saved found set. You can reuse the data in a saved set, delete the saved set, or view a listing of the saved sets.

LIBRARY

Create, delete, edit, execute, or submit a query. You can modify the extended definition of a query which includes specifying the query status as PRIVATE or PUBLIC and modify the groups assigned to that query or the author of that query. You can also create queries, establish dialog definitions, submit and validate queries. You can also edit queries created by others. The LIBRARY function maintains the attributes (extended definitions) of the Query Library Table members.

SECURITY CONTROL

(DQL Mode only) Authorize access to a CA Datacom/DB database (to all of its tables) or authorize access to a specific CA Datacom/DB tables within a database. DQL table security is in effect only if CA Dataquery has not been externally secured. You can display a list of all users authorized to access a particular CA Datacom/DB database, or display a list of all the tables that a user is authorized to use. You can name the CA Datacom/DB Database Identifier (DBID) and the tables that you are authorizing a user to access, or select the user and then name the DBID and the tables you want him to access. You can copy security from one user to another as well as add, delete, and update profile codes.