Managing Your Query Library Table › Accessing the Admin DIRECTORY OF QUERIES AND TERMS

Accessing the Admin DIRECTORY OF QUERIES AND TERMS

Use the Admin DIRECTORY OF QUERIES AND TERMS to access the administrative Query Library Table maintenance functions.

Access

Enter selection criteria from panel DQEM0 and press Enter to display the query Library Directory.

The Admin DIRECTORY OF QUERIES AND TERMS panel looks like the DIRECTORY OF QUERIES AND TERMS panel for users. However, each user only sees a listing of the queries, dialogs, and terms for which he is authorized. You see a listing of all users' queries, terms, and dialogs at your site which have a group level authorization that matches your group level authorization if your query library is partitioned by groups (QRYGRPS=YES in the DQ System Option Table).

The Admin DIRECTORY OF QUERIES AND TERMS lists queries and dialogs for either DQL mode or SQL mode, depending on the mode of the Administrator. (The LIST QUERY command displays a directory that contains only those queries for the current setting of the query language.)

An example of the Admin DIRECTORY OF QUERIES AND TERMS panel follows.

DIRECTORY OF QUERIES AND TERMS (DQA30)

 =>
 Place the cursor on the desired name and press the appropriate PF key
 ------------------------------------------------------------------------DQA30
 DATAQUERY: ADMIN DIRECTORY OF QUERIES AND TERMS   START WITH: ________________
 -----------------------------------------------------------------------------
     QUERY NAME    |  TYPE  | CREATED  |   USED   |     DESCRIPTION
 -----------------------------------------------------------------------------
                   |        |          |          |
                   |        |          |          |
                   |        |          |          |
                   |        |          |          |
                   |        |          |          |
                   |        |          |          |
                   |        |          |          |
                   |        |          |          |
                   |        |          |          |
                   |        |          |          |
                   |        |          |          |
                   |        |          |          |
 --------------------------------------------------------------------------- ==>
 <PF1> HELP         <PF2>  RETURN        <PF3>  EXECUTE     <PF4>  EDIT
 <PF5> NOT USED     <PF6>  DELETE        <PF7>  BACKWARD    <PF8>  FORWARD
 <PF9> SUBMIT       <PF10> EXTENDED DEF  <PF11> NOT USED    <PF12> RIGHT

Action

The START WITH: field, located in the upper-right corner of this panel is where you enter the full or partial name of the query or term where you want the listing to start. When you press Enter, CA Dataquery refreshes the DIRECTORY OF QUERIES AND TERMS panel with the query, dialog, or term that you specified on the first line of the listing. You can also page forward using <PF8> FORWARD until you reach the member that you wish to view or edit.

Panel Description

The following list describes each column of the DIRECTORY OF QUERIES AND TERMS panel:

QUERY NAME

Lists alphabetically all existing query, dialog, and term names.

TYPE

Specifies whether this is a query, dialog, or term, SQL query, or SQL dialog.

CREATED

Displays the date the named query, dialog, or term was created.

USED

Displays the date this query, dialog, or term was last accessed.

DESCRIPTION

Displays a description of this query, dialog, or term as entered on the Editor panel.

STATUS

Displays the status (public or private) as assigned to this query, dialog, or term.

AUTHOR

Displays the name of the author of this query, dialog, or term.

GROUPS

Lists Level 1, Level 2, and Level 3 groups assigned to this query, dialog, or term, if any.

To view the STATUS, AUTHOR and GROUPS columns press <PF12> RIGHT. This PF key shifts the panel display to the right.

Note: <PF11> NOT USED exists on the panel until you press <PF12> RIGHT to view the last three columns. Use <PF11> LEFT to shift the panel display to its original state.

Action

CA Dataquery uses the DIRECTORY OF QUERIES AND TERMS panel to perform several functions on queries by PF key selection. Your use of these PF keys is for a different purpose than that of the average user. Following are listed some examples of how to use the functions:

• To execute a query or dialog to test or debug that query or dialog by executing only the selection, computation, sorting, or reporting portion of that query or dialog.
• To view or edit a user's query to aid the user with problem resolution, to edit the query to meet site standards, or to edit the query after the author leaves your company's employment or changes positions within the company.
• To delete queries as they are no longer used, are not functional or no longer meet the needs of your company, and so forth.
• To submit your own queries.
• To access a user's queries, dialogs or terms, when a user's status changes, such as a change in job position responsibilities or a departure from your company. You can delete any unnecessary ones and reassign the usable ones to other users and or groups.
• To change the status of a user's queries from PRIVATE to PUBLIC or from PUBLIC to PRIVATE.

PF Keys

The following list describes each PF key for the DIRECTORY OF QUERIES AND TERMS panel.