Using GUIDE in DQL Mode › Creating a Sample › Step 1: Name the Query and its Library

Step 1: Name the Query and its Library

DQH10

When you select GUIDE from the Main Menu, the GUIDED QUERY CREATION: OPTION Selection panel (DQHV0) appears. On it, you mark the options you want to define for the query to be created. For this sample, all options are marked. Therefore, the sample steps discuss each GUIDED QUERY panel.

 =>

 --------------------------------------------------------------------------DQH10
 DATAQUERY:   QUERY IDENTIFICATION
 -------------------------------------------------------------------------------

 ENTER A UNIQUE NAME FOR THE NEW QUERY ==>   _______________

 SELECT THE ACCESSIBILITY LEVEL FOR YOUR QUERY BY PLACING ANY CHARACTER
 NEXT TO YOUR CHOICE.

   _  PUBLIC
   X  PRIVATE

 ENTER A DESCRIPTION FOR THE NEW QUERY
   ==> ___________________________________________________________





 -------------------------------------------------------------------------------
 <PF1> HELP         <PF2> RETURN        <PF3> NOT USED      <PF4>  CONTINUE

If you are not certain how to complete a panel, you can press <PF1> HELP to get information about the panel or read the documentation about the panel in the CA Dataquery Reference Guide. Then you decide how you want to complete it.

Purpose

The required QUERY IDENTIFICATION panel names the query, tells CA Dataquery the library in which to keep it, and provides a short description for the library directory. When you complete this panel and press Enter, the query resides in that library unless you delete it during a directory display.

Concepts

These are the major concepts related to this panel:

Name
A query name must be unique within its assigned library and must be one word of 1 to 15 alphabetic characters, numbers, or dashes. Library
The library (public or private) is the place in which CA Dataquery is to store the query. At some sites, if you assign a query to the public library, you cannot change or delete it. CA Dataquery provides an installation option which determines whether the author of a public query can change or delete it. Your CA Dataquery Administrator can answer any questions you have concerning public libraries at your site. The library in which you store your query determines whether other users can access and use it.

Description
A description should tell the query's purpose and note anything that makes it unique. It cannot exceed 60 characters in length.

Panel Operation

The Tab key moves the cursor from one field to another. You type entries, and press <PF4> CONTINUE (or Enter) to display the next panel.

Note: For complete instructions on operating this panel, see the CA Dataquery Reference Guide.

Completed Example

The following completed panel shows how to complete the QUERY IDENTIFICATION panel to produce the sample report.

 =>

 --------------------------------------------------------------------------DQH10
 DATAQUERY:   QUERY IDENTIFICATION
 -------------------------------------------------------------------------------

 ENTER A UNIQUE NAME FOR THE NEW QUERY ==>   USER-SAMPLE____

 SELECT THE ACCESSIBILITY LEVEL FOR YOUR QUERY BY PLACING ANY CHARACTER
 NEXT TO YOUR CHOICE.

   _  PUBLIC
   X  PRIVATE

 ENTER A DESCRIPTION FOR THE NEW QUERY
   ==> TOTAL ORDERS PER CUSTOMER -- AVERAGE PRICE_________________





 -------------------------------------------------------------------------------
 <PF1> HELP         <PF2> RETURN        <PF3> NOT USED      <PF4>  CONTINUE

This chart explains each entry/selection.

Options

You could give your query a name that shows its history and relationship to other queries, like USER-SAMPLE-1. You could then change the number as you refine the query. Thus, the name would show a history. Your query description might even include a user's name, if you create one for someone else and place it in the public library. Your CA Dataquery Administrator may provide guidelines for naming queries at your site.

To Go to the Next Step

Pressing <PF4> CONTINUE displays the next panel.