To run a DIRECTORY, you need to be at the VMS prompt. You can pass to the VMS command level from within the Guided Query Language.

First, use the arrow key to select the exit option on the Guide Options menu and exit out of the GQL menu interface.

+--------------------------------Guide Options---------------------------------+ |<< OPEN RELATE SELECT SORT PRINT GO EDIT MORE exit | +------------------------------------------------------------------------------+

You will now be at the Guide prompt.

To get to the VMS prompt, type $$ (two "$" signs) and press the [RETURN] key.

Guide> $$

This clears the screen and GQL passes you to the VMS command level.

The screen appears as follows:

Example 3-3 Pass to VMS from within GQL

Passed to VMS... Press RETURN when done. USER:[TESTER] $$

Type the words DIRECTORY CLIENT_LIST at the $$ prompt.

$$ DIRECTORY CLIENT_LIST

You will see that the GQL command file has been saved.

Directory USER:[TESTER] CLIENT_LIST.GUIDE;1 Total of 1 file. $$

Press the [RETURN] key twice to get out of VMS and back to the Guide prompt.

The commands for the "CLIENT LIST" report have been saved on disk in the CLIENT_LIST.GUIDE file and the report can be run at any time. The following section will explain how to do this.

3.3 Running a Saved Report

As an example, we will retrieve the CLIENT_LIST.GUIDE file and run the "CLIENT LIST" report.

To begin, we must get to the Guide prompt.

Guide> EXIT = Exit INTOUCH Guided Query Language HELP = Help

Type the words OLD CLIENT_LIST at the Guide prompt and press the [RETURN] key.

Guide> OLD CLIENT_LIST

GQL displays the report information.

+--------------------------------Guide Options---------------------------------+ |<< OPEN RELATE SELECT SORT PRINT GO EDIT MORE exit | +------------------------------------------------------------------------------+ CLIENT LIST Pos: 68 CLNT First Last ID Name Name City ST ----- --------------- ----------------- ------------------------- -- XXXXX XXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXX XX Guide> CLIENT opened...fields: 18 EXIT = Exit INTOUCH Guided Query Language HELP = Help

Use the arrow keys to select the GO option from the Guide Options menu.

GQL processes the CLIENT_LIST.GUIDE command file and generates the "CLIENT LIST" report.

There are many commands in the Guided Query Language. Creating the sample "CLIENT LIST" report required only a few of the commands.

To get familiar with a variety of the GQL commands and their uses, you can run the TTI TRAINING SYSTEM.

The TTI TRAINING SYSTEM is a series of Tutorials designed to guide you, step by step, through the creation of various GQL reports. For example, you learn how to:

• Sort information in a particular order
• Perform calculations
• Group information
• Relate a master file to detail information
• Summarize reports

4.1 TTI TRAINING SYSTEM

It would be very beneficial to run the TTI TRAINING SYSTEM before attempting to write more complex GQL reports.

This chapter recaps information discussed in previous chapters and describes some of the commonly used GQL commands.

All the GQL commands that are mentioned in this chapter and elsewhere in the manual can be accessed either at the Guide prompt or from the GQL menu interface.

5.1 The HELP and EXIT Commands

Guide> Type HELP for assistance EXIT = Exit INTOUCH Guided Query Language HELP = Help

At the bottom of the screen, an informational message is displayed. The commands shown in the lower frame can be used at any time while you are in the Guided Query Language.

Table 5-1 Guided Query Language HELP and EXIT Commands

Command	Description
HELP	You can get help by typing HELP at the Guide prompt or by pressing the [Help] key. This will cause GQL to provide you with helpful information.
EXIT	You can exit the GQL environment by typing EXIT at the Guide prompt. You will be returned to the system prompt ($).

5.2 Working in VMS

Guide> $$

This clears the screen and GQL passes you to the VMS command level. When you have finished working in VMS, press the [RETURN] key twice. The Guide prompt will reappear:

Guide>

5.3 Some Commonly Used GQL Commands

You will find it easy to write a report using just a few simple Guided Query Language commands. Some of the commonly used commands are:

Table 5-2 Commonly Used GQL Commands

Command	Description
NEW	Start a new report.
OPEN	Open a data structure.
SHOW FIELDS	Show the fields in the record.
INCLUDE	Include specific fields on the report.
SORT	Sort fields for the report.
PRINT	Select the fields to be printed on the report.
GO	Generate the report.
SAVE	Save the report command file.

5.4 Starting a Report

Example 5-1 Starting a New Report

Guide> NEW Type HELP for assistance EXIT = Exit INTOUCH Guided Query Language HELP = Help

The message New program is displayed.

To tell GQL which structure or structures you want to work with, enter OPEN and the name of the data structure at the Guide prompt.

For example, you might want to use a structure called PRODUCT to make a list of products. At the Guide prompt, enter OPEN PRODUCT.

Example 5-2 Opening a Structure

Guide> OPEN PRODUCT PRODUCT opened...fields: 7 EXIT = Exit INTOUCH Guided Query Language HELP = Help

The number of fields in the PRODUCT record is displayed.