Operating CA Dataquery › Selecting a Directory

Selecting a Directory

CA Dataquery stores queries and dialogs created by you and other users in a public library that is shared by other users or in the author's private library. The author designates the library. Queries and dialogs can be further restricted by the CA Dataquery Administrator so that they appear in your public library only if you are authorized to use them. To select an item from a library, display a directory list for any type of item.

When you select DIRECTORIES from the CA Dataquery MAIN MENU, the DIRECTORY SELECTION panel lets you specify the kind of directory you want CA Dataquery to display. You can display directories of libraries and accessible database tables.

SQL Panel

Use the following panel to display an SQL Mode directory.

=>
Mark the desired Directory and press Enter.
------------------------------------------------------------------------DQAK0
DATAQUERY:  DIRECTORY SELECTION
-----------------------------------------------------------------------------

  _ Queries and Dialogs        - List queries and Dialogs accessible to you.
  _ Queries                    - List queries accessible to you.
  _ Dialogs                    - List Dialogs accessible to you.
  _ Public Queries             - List public queries.
  _ Queries                    - List queries created by user:
                                  ________________________________

  _ Tables                     - List the Tables accessible to you.
                                 Start Tables Directory with Letters:
                                  ________________________________
                          





-----------------------------------------------------------------------------
<PF1> HELP         <PF2>  RETURN

DQL Panel

Use the following panel to display a DQL Mode directory.

=>
Mark the desired Directory and press Enter.
------------------------------------------------------------------------DQA40
DATAQUERY:  DIRECTORY SELECTION
-----------------------------------------------------------------------------

  _ Queries and Terms        - List all queries and terms accessible to you.
  _ Queries Only             - List queries accessible to you.
  _ Terms Only               - List terms accessible to you.
  _ Dialogs                  - List Dialogs accessible to you.
  _ Public Queries           - List public queries.
  _ Queries and Terms        - List queries and terms created by user:
                                ________________________________

  _ Tables                   - List the tables accessible to you.
                               Start Table Directory with Letter:
                                ________________________________
  _ Saved Sets               - List the saved sets.




-----------------------------------------------------------------------------
<PF1> HELP         <PF2>  RETURN

Operation

Specify which directory you want to see by placing a character in the field preceding its name and pressing Enter. For detailed information about each directory panel and its operation, see the CA Dataquery Reference Guide. The following lists the directories you can display.

Queries

Public and private library of queries you can access.

Dialogs

Public and private library of dialogs you can access.

Terms

Public and private library of terms you can access. Terms are available only in DQL Mode.

Public queries

All public library queries and dialogs you can access.

Queries by user __

Public library listing of queries and dialogs created by an individual user. Shows your private queries too if you enter your own user ID.

Tables

All database tables you are authorized to access.

Saved sets

(DQL Mode only.) All saved sets of query output you can access. See Saving and Using DQL Mode Sets for detailed information.