INTOUCH® Guided Query Language

INTOUCH®
Guided Query Language

Touch Technologies, Inc.
10650 Scripps Ranch Blvd., Suite 100
San Diego, California 92131
Phone (800) 525-2527
FAX (619) 566-3663

Note

® VAX is a registered trademark of Digital Equipment Corporation.

® INTOUCH is a registered trademark of Touch Technologies, Inc.


NOTICE

Touch Technologies, Inc. (TTI) has prepared this publication for use by TTI personnel, licensees, and customers. This information is protected by copyright. No part of this document may be photocopied, reproduced or translated to another language without prior written consent of Touch Technologies, Incorporated.

TTI believes the information described in this publication is accurate and reliable; much care has been taken in its preparation. However, no responsibility, financial or otherwise, is accepted for any consequences arising out of the use of this material.

The information contained herein is subject to change without notice and should not be construed as a commitment by Touch Technologies, Inc.

The following are trademarks of Touch Technologies, Inc., and may be used only to describe products of Touch Technologies, Inc.:


DYNAMIC TAPE ACCELERATOR        INTOUCH 4GL 
 
DYNAMIC LOAD BALANCER PLUS      REMOTE DEVICE FACILITY 

The following are trademarks of Digital Equipment Corporation, and may be used only to describe products of Digital Equipment Corporation:


DBMS      DCL      DECNET      VMS/OpenVMS      RDB      RMS      VAX 

Revised: May 1999 for V4.5

Copyright ©1992, 1999 Touch Technologies, Inc.

Contents Index


Preface

The Guided Query Language (GQL) is a natural language INTOUCH interface. GQL is intended for end-users who want to access complex databases for report design and generation. GQL helps you to easily and quickly write these reports without spending costly hours learning a traditional procedural language.

The Guided Query Language:

GQL provides the user with a simple command repertoire powerful enough to allow:

You will find the Guided Query Language the perfect tool for report design and generation. A simple set of commands entered by the end-user causes GQL to build an INTOUCH program. This program rapidly and efficiently builds the necessary report.

About this Manual

This manual describes the Guided Query Language interface to the INTOUCH system. For more information on INTOUCH, refer to the following manuals:

A Guide to the Language describes the INTOUCH system and how to develop programs with it. The manual explains the development cycle and INTOUCH's features for speeding up this cycle. It describes the INTOUCH environment, program elements and the INTOUCH language and debugging system.

The Specifications manual contains a brief description of the INTOUCH system, statements, commands, etc. and some background on how the system operates.

Purpose

The purpose of this document is to present information you will need to start using the Guided Query Language interface. The intent is to provide you with simple and concise explanations of the Guided Query Language system, features, and language. This manual is designed to provide a basic and thorough explanation of each element. It can also be used as a reference guide by advanced users.

Intended Audience

This manual is written for anyone interested in using The Guided Query Language. Since no programming experience is necessary to successfully create reports with GQL, this document contains no programming jargon. The manual can be easily referenced by computer users of all levels.


Chapter 1
Using the Guided Query Language

The Guided Query Language (GQL) is very easy to use. As an aid to new users, a menu interface is available to get you acquainted with the language.

The menu interface will provide you with the commands you need to create a report. After you get familiar with the GQL commands, you can easily expand your report writing skills.

1.1 Getting Started

You can start the Guided Query Language by typing the word GUIDE at the system prompt ($) in upper or lower-case letters.


        $ GUIDE

The Guided Query Language will be initialized and you will see the GQL screen:

Example 1-1 Guide Screen


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

1.2 Menu Interface

The easiest way to get familiar with the Guided Query Language commands is to use the GQL menus. The menu interface displays the Guide options and commands that you will use to create your report.

To get into the GQL menu interface, type the words SET MENU ON at the Guide prompt.


        Guide> SET MENU ON

When the GQL menu interface is set on, a list of Guide options is displayed.

Example 1-2 Guide Options Menu


+--------------------------------Guide Options---------------------------------+ 
|  TITLE    OPEN    MAKE    SET    SHOW    EDIT    MORE    exit                | 
+------------------------------------------------------------------------------+ 
 
 
 
 
 
                                                                                
 
 
 
 
 
Guide> 
 
                       Menu interface has been turned on 
EXIT = Exit             INTOUCH Guided Query Language                HELP = Help

Note

The [PF4] key can also be used at anytime to ENTER or EXIT the GQL menu interface.

1.2.1 Selecting GQL Menu Options

Use the arrow keys to move back and forth across the top of the screen to select an option. After an option is selected, press the [RETURN] key to execute that option.

Some options have submenus. To select an item from a submenu, use the arrow keys to move up and down (and sometimes across). After you have selected an item from the submenu, press the [RETURN] key to execute that item.

If you select the wrong menu option or item, press the "\" key and you will be returned to the menu or submenu.

The symbols << and >> mean that there are more menu options or items than can be displayed on the screen. To see what the options or items are, move the arrow key in that direction.


Next Contents Index