Step 3: Identify and Save the Query

Using GUIDE in SQL Mode › Creating a Sample Query › Sample Procedure › Step 3: Identify and Save the Query

Step 3: Identify and Save the Query

This section describes how to complete the QUERY IDENTIFICATION panel and shows you how to complete it for the sample business problem.

To Start

After you select options for the query, CA Dataquery presents the following panel.

Query Identification (DQHI0)

 =>

 --------------------------------------------------------------------------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

Facts

The following presents some facts needed to complete the Query Identification panel for the sample query.

Enter a unique name...: A query name must be unique within its assigned library and must be one word of 1 to 15 alphabetic characters, numbers, underscores, or special characters. The first character must be a letter.
Select the accessibility...: The selections are PUBLIC or PRIVATE. You can update and delete queries saved in your private library. If you assign a query to the public library, others can use it, and you cannot change or delete it unless your site permits. Contact your CA Dataquery Administrator for procedures at your site.
Enter a description...: A description is recommended but not required. A description should tell the query's purpose and note anything that makes it unique. The description cannot exceed 60 characters.
<PF4> CONTINUE: Once you press <PF4> CONTINUE on the QUERY IDENTIFICATION panel, the query is saved and resides in the library you specified on the panel. Thereafter, each time you press <PF4> CONTINUE during display of a panel, the query is updated.

Action

The following chart shows how to complete this panel so that it identifies the sample query:

Field	Enter	Reason
Name	SQLGUIDE	Readily shows that this is an SQL query created with the GUIDE function.
Accessibility level	PRIVATE	Since this is a practice query, it may not be needed by others. Its library assignment can always be changed via the EDITOR panel.
Description	CAI_SLSHST_TBL table, all rows, sorted by ITM_ID	Describes the table the query accesses, whether or not selection criteria is applied (it is not), and says that the output is sorted. During directory display, you can see right away whether or not the query meets your need.

Field

Enter

Reason

Name

SQLGUIDE

Readily shows that this is an SQL query created with the GUIDE function.

Accessibility level

PRIVATE

Since this is a practice query, it may not be needed by others. Its library assignment can always be changed via the EDITOR panel.

Description

CAI_SLSHST_TBL
table, all rows,
sorted by ITM_ID

Describes the table the query accesses, whether or not selection criteria is applied (it is not), and says that the output is sorted. During directory display, you can see right away whether or not the query meets your need.

With all fields complete, press <PF4> CONTINUE to save the query identification and library assignment and to go on to the next panel.

Options

The following lists other things you could do with this panel.

Use a different name: You can create a query name that is up to 15 characters long. You can use numbers and hyphens anywhere after the first character.
Omit a description: If a description is unimportant to you, you can leave it off. You can always add a description later using the EDITOR panel.