Digital PDFs

AA-U052B-TC

November 1987

58 pages

Original

2.2MB

Document:	DATATRIEVE-11 Summary Nov87
Order Number:	AA-U052B-TC
Revision:	0
Pages:	58
Original Filename:	AA-U052B-TC_DATATRIEVE-11_Summary_Nov87.pdf

OCR Text

DATATRIEVE-11
Summary Description
Order No. AA-U052B-TC

November 1987

This manual provides an overview ofDATATRIEVE-Il. It contains a
glossary ofDATATRIEVE concepts and terms and a master index to the
documentation set.

OPERATING SYSTEMS:

RSX-IIM
RSXIIM-PLUS
RSTS/E
Micro/RSX
Micro/RSTS
VMS with VAX-II RSX

SOFTWARE VERSION:

DATATRIEVE-II V3.2

digital equipment corporation, maynard, massachusetts

The information in this document is subject to change without notice and should
not be construed as a commitment by Digital Equipment Corporation. Digital
Equipment Corporation assumes no responsibility for any errors that may
appear in this document.
The software described in this document is furnished under a license and may be
used or copied only in accordance with the terms of such license.
No responsibility is assumed for the use or reliability of software on equipment
that is not supplied by DIGITAL or its affiliated companies.

The postage-paid Reader's Comments forms at the end of this document request
your critical evaluation to assist us in preparing future documentation.

The following are trademarks of Digital Equipment Corporation:

~D~DDmD ™
ACMS
CDD
DATATRIEVE
DEC
DECnet
DECUS
Micro/RSTS

Micro/RSX

MicroVAX
MicroVMS
PDP
RALLY
Rdb/ELN
Rdb/VMS
ReGIS
RSTS
RSX
TDMS

TEAMDATA
UNIBUS
VAX
VAXcluster
VAXinfo
VAX Information Architecture
VAXNMS
VMS
VT

Contents
Page

How to Use This Manual

1 DATATRIEVE-11 Overview
1.1
1.2
1.3
1.4

What Is DATATRIEVE? . . . . . . . . . . . . . . . .
Who Is DATATRIEVE For? . . . . . . . . . . . . . .
How Is DATATRIEVE Different from COBOL or BASIC?
Information Management with DATATRIEVE
1.4.1

Data Definition . . . . . .
1.4.1.1
1.4.1.2
1.4.1.3

1.4.2
1.4.3
1.4.4
1.4.5
1.4.6
1.4.7
1.4.8

Simple Domains . . . . .
View Domains . . . . . .
The Application Design Tool

· 1-1
· 1-2
· 1-2
· 1-3
· 1-3
· 1-3
· 1-4
· 1-4

Data Storage . . . . . . .
Data Retrieval . . . . . .
Procedures . . . . . . . .
The Report Writer Facility.
GuideMode . . . . . . . .
The DATATRIEVE Editor .
Distributed Data Access and Call Interface.

· 1-4
· 1-4
· 1-5
· 1-5
· 1-6
· 1-6
· 1-7

1.4.8.1
1.4.8.2

· 1-8
· 1-8

Remote Terminal Interface
Call Interface . . . . . .

2 DATATRIEVE-11 Documentation Directory
2.1
2.2
2.3
2.4
2.5
2.6
2.7
2.8
2.9

DATATRIEVE-11 Installation Guide . .
DATATRIEVE-11 Online Release Notes
DATATRIEVE-11 Summary Description
Introduction to DATATRIEVE-11
DATATRIEVE-11 User's Guide . . . . .
DATATRIEVE-11 Guide to Writing Reports
DATATRIEVE-11 Call Interface Manual
DATATRIEVE-11 Reference Manual
DATATRIEVE-11 Pocket Guide

· 2-1
· 2-1
· 2-2
· 2-2
· 2-2
· 2-3
· 2-3
· 2-3
· 2-4

Glossary
Master Index
Figures
1-1

Distributed Data Access and Call Interface . . . . . . . . . . . . . . . . . . . . . . . 1-7

iii

How to Use This Manual

This manual provides an overview of DATATRIEVE-l 1. It contains a documen~
tation directory, a glossary ofDATATRIEVE concepts and terms, and a ma.ster
index to the documentation set.

Intended Audience
This manual is intended for people who want to know:
• What DATATRIEVE is
• What DATATRIEVE does
• What software works with DATATRIEVE
• Where to find information about DATATRIEVE

Structure
This book is divided into two chapters, a glossary, and a master index:
Chapter 1

Provides an overviewofDATATRIEVE-ll.

Chapter 2

Outlines the DATATRIEVE-ll documentation set.

Glossary

Defines terms used throughout DATATRIEVE-ll
documentation.

Master Index

Contains references to subjects in all DATATRIEVE-'-ll
documentation.

DATATRIEVE-11 Overview

This chapter gives you an overview ofDATATRIEVE-l1. It explains when to use
DATATRIEVE, how to use DATATRIEVE to define and manipulate your data,
and how the special features of DATATRIEVE allow you to manage data. If any
of the terms are unfamiliar to you, refer to the glossary. If you want detailed
information about subjects discussed here, consult the master index.
This chapter is not intended to serve as an interactive session with
DATATRIEVE. Examples in this chapter include only the text ofDATATRIEVE
commands, statements, and output, without system prompts and other information that appears on your screen when you actually use DATATRIEVE. See the
Introduction toDATATRIEVE-ll or DATATRIEVE-ll User's Guide for more
information on using DATATRIEVE.
In this manual, the DATATRIEVE-ll software is referred to as DATATRIEVE.

1.1

What Is DATATRIEVE?
DATATRIEVE is a comprehensive data management tool. It provides the following capabilities:
• A query language for defining, storing, updating, and displaying data
• A facility for writing reports
• Interactive and program-callable access to data
• Access to data distributed on a network connected by DECnet

1-1

1.2

Who Is DATATRIEVE For?
DATATRIEVE is designed for use by people with little or no computer experience and by people who are experienced users of computers.
Typical tasks DATATRIEVE-ll performs range from answering a casual question to creating a complex report. For example, using DATATRIEVE, you can
query a personnel data file to determine which employees work in a particular
department. You can use the same personnel file to produce a report with a statistical analysis of employee compensation by experience level.
You'can also use DATATRIEVE-ll in a distribution facility with an order
processing system. In this setting, you might want to extract sales data by territory and print a report using that data.

1.3

How Is DATATRIEVE Different from COBOL or BASIC?
DATATRIEVE is a "fourth-generation" language. This means that its syntax is
more like English than that of BASIC or COBOL. DATATRIEVE executes commands and statements as you type them. You can tell DATATRIEVE what information you want by name, instead of specifying how to obtain the information as
you would in COBOL or BASIC.
In COBOL or BASIC, each program describes the structure of the data it uses.
DATATRIEVE lets you define data structures and stores those definitions separately. You can retrieve the data and use it in any number of ways without redefining the data each time.
DATATRIEVE also handles other common language functions automatically,
without the need for language statements. For instance, DATATRIEVE:
• Finds data files and opens them
• Performs input and output operations
• Formats data for output
• Converts data types
As a result, you save many lines of code and applications run faster. In addition,
the code is much more readable than COBOL or BASIC. For example, a typical
programming language might retrieve the records of all employees named Perry
like this:
LOOP:

READ EMPLOYEE-FILE
AT END E}OT
IF LAST_NAME NOT = "PERRY"
GO TO LOOP
PRINT FIRST_NAMEt LAST_NAMEt ADDRESS •••
GO TO LOOP

In DATATRIEVE, this becomes:
PRINT EMPLOYEES WITH LAST_NAME

1-2

DATATRIEVE-11 Overview

"PERRY"

1.4

Information Management with DATATRIEVE
DATATRIEVE is a tool for managing data. Using DATATRIEVE, you can:
• Define data in a way that fits your information management needs
• Store and modify data
• Retrieve data and display it on a terminal, record it in a file, or print it on
paper
• Format data in reports
• Use a text editor to correct typing and syntax errors
• Access data files that are distributed across a network
• Call any of the information services ofDATATRIEVE from a program written
in a high-level programming language such as COBOL or BASIC

1.4.1

Data Definition

To create a DATATRIEVE-ll information management application, follow
these two steps. First, define the data that you will use with DATATRIEVE commands. You need to define data only once to establish the foundation on which to
build your applications. Second, use DATATRIEVE statements to process the
data associated with these definitions.
The data definition process involves creating DATATRIEVE domains. Domains
represent relationships between actual physical data and descriptions of data.
DATATRIEVE performs all data management in terms of domains.
In its simplest form, a DATATRIEVE domain definition consists of the name of the domain and the names of the record definition
and data file associated with it. Here is an example of a domain definition:
1.4.1.1

Simple Domains -

DEFINE DOMAIN PERSONNEL USING PERSONNEL_RECORD ON PERSON.DAT;

The record definition, PERSONNEL_RECORD, describes the data you want to
use. The data file, PERSON.DAT, contains the data. The domain you created,
PERSONNEL, connects the description with the data.
To use a domain, first get access to it with the READY command:
READY PERSONNEL

. After you ready a domain, you can instruct DATATRIEVE to display data with a
statement such as:
PRINT FIRST 2 PERSONNEL

DATATRIEVE-11 Overview
"

1-3

In response to this statement, DATATRIEVE checks the record definition, gets
the data requested from the file, and displays the following lines on your
terminal:
ID

STATUS

FIRST
NAME

00012 EXPERIENCED CHARLDTTE
00881 EXPERIENCED FRED

LAST
NAME
SPIVA
HOWL

DEPT
TOP
Fll

START
DATE

SALARY

SUP
ID

12-Sep-1872 $75t882 00012
8-Apr-1876 $58t584 00012

If you want to put this information in a file, you can specify an output file:
PRINT FIRST 2 PERSONNEL ON FILE.DAT

You can send the information to a line printer using this statement:
PRINT FIRST 2 PERSONNEL ON LP:
1.4.1.2

View Domains - A view domain is a special type of domain that allows

you to include any combination of fields and records from one or more domains.
This means that you can define a view that selects information from a number of
domains. View domains provide a way to reorganize data without changing the
files storing the information. You can use a view domain just as you use a simple
domain.
1.4.1.3 The Application Design Tool - The Application Design Tool (ADT) is a

DATATRIEVE utility that simplifies the process of defining domains. ADT operates interactively and queries you for information. Your responses to the questions enable ADT to define a domain, define a record format, and create a data
file. To start the Application Design Tool, type ADT.

1.4.2

Data Storage

Information management applications require that files be filled with data. Use
the DATATRIEVE STORE statement for this purpose. When you enter a STORE
statement, DATATRIEVE prompts you for field values. Before accepting input,
DATATRIEVE also performs any validation checks specified by the record
format.

1.4.3

Data Retrieval

You use data to make decisions, generate reports, and make your work easier.
DATATRIEVE allows you to retrieve stored data with a set of statements. You
need not be concerned with the underlying data structure or with the physical
location of the data.
Data retrieval statements in DATATRIEVE consist of verbs modified by record
selection expressions (RSEs). An RSE is a phrase that allows you to specify only
the records you want from one or more domains. One DATATRIEVE statement
can get the answer to a casual query or produce a detailed report.

1-4

DATATRIEVE-11 Overview

A typical data retrieval statement is:
FIND PERSONNEL WITH START_DATE GT "Ol-Jan-1982"

This statement establishes a collection of records. It might yield a response such
as:
[50 records found.]

Subsequent FIND statements can narrow down this CURRENT collection of 50
records. For example:
FIND CURRENT WITH DEPARTMENT EQUAL "SALES" OR "MARKETING" AND
ZIP_CODE EQUAL 02138

DATATRIEVE may respond with:
[4 records found.]

You can then use the PRINT statement to display the collected data on the terminal screen, record it in a file, or print it on paper. For example, to display the
data on your terminal screen:
PRINT ALL NAMEt ADDRESSt PHONE

1.4.4

Procedures

With the DEFINE PROCEDURE command, you can specify sequences of
DATATRIEVE-ll commands and statements and store them in a data dictionary for later use. You can invoke procedures by themselves and embed them in
other procedures. You can use a procedure interactively or have an applications
program invoke the procedure.

1.4.5

The Report Writer Facility

The DATATRIEVE Report Writer provides a set of formatting options for producing printed reports with page and column headings, page numbers, totals, subtotals, and other summary information.
You can tell the Report Writer what data and records to include in the report,
what to title the report, what headings to print at the top of each page, and what
summary lines to include. You can also tell the Report Writer to perform mathematical operations and can include the results of these operations in your report.

DATATRIEVE-11 Overview

1-5

The following example shows how the Report Writer formats a page. The page
has the date and page number in the upper right corner. In this example, the
Report Writer automatically sets the page width to 80 columns, spacing the
fields of each record for you. Use the REPORT statement to invoke the Report
Writer:
REPORT PERSONNEL WITH DEPT = "Fll"
SET REPORT_NAME = "DEPARTMENT Fll: EMPLOYEES
PRINT ID, STATUS, NAME, START_DATE
END_REPORT

The Report Writer formats your report as follows:
DEPARTMENT Fll: EMPLOYEES

23-Jul-8~

Page 1

STATUS

FIRST
NAME

LAST
NAME

START
DATE

00891
32432
78923
87701

E>{ PER I ENCED
TRAINEE
E~< PER I ENCED
TRAINEE

FRED
THOMAS
LYDIA
NATHANIEL

HOWL
SCHWEIK
HARRISON
CHONTZ

9-Apr-7G
7-Nol.l-81
19-Jun-79
28-Jan-82

1.4.6

Guide Mode

DATATRIEVE provides a self-teaching facility named Guide mode. To invoke
Guide mode, issue the SET GUIDE command. Guide mode helps you through a
DATATRIEVE session with a series of questions. At any time in this mode of
operation, you can request a list of commands, statements, names, or value
expressions that you can enter.
Guide mode is particularly useful to the inexperienced user who wants assis- .
tance during a DATATRIEVE session.

1.4.7

The DATATRIEVE Editor

The DATATRIEVE Editor allows you to modify existing domain, record, procedure, and table definitions stored in your current data dictionary. You can substitute characters and insert, replace, delete, and display lines in a dictionary
definition.
Any mistakes you make while modifying your definitions are not checked by the
DATATRIEVE Editor, however. You may want to define your DATATRIEVE elements as procedures or command files. You can then modify them as many times
as necessary, and invoke the procedure or command file to store each version of
the definition in DATATRIEVE.

1-6

DATATRIEVE-11 Overview

1.4.8

Distributed Data Access and Call Interface

The DATATRIEVE Remote Terminal Interface and Call Interface give you
access to distributed data and allow you to call DATATRIEVE from programs in
high-level languages. The Call Interface includes a Local Call Interface, for calls
to DATATRIEVE on your local PDP-II node and a Remote Call Interface, for
calls to DATATRIEVE on another node connected to your system. Figure 1-1
shows this relationship.
PDP-11 Node

PDP-11 Node

Calling
Program

DATATRIEVE
Remote
Terminal
Interface

RUN $REMDTR

DATATRIEVE
Local
Call
Interface

DATATRIEVE
Remote
Call
Interface

Task-to-Task
Communication

PDP-11 Node

PDP-11
Node

DATATRIEVE
Local
Server

Data
Files

Data
Dictionaries

VAX Node

DATATRIEVE
Distributed
Server

Data
Files

DATATRIEVE
Distributed
Server

Data
Dictionaries

Common Data
Dictionary

Data
Files

ZK-6305-HC

Figure 1-1: Distributed Data Access and Call Interface

DATATRIEVE-11 Overview

1-7

1.4.8.1 Remote Terminal Interface - The DATATRIEVE Remote Terminal Interface (REMDTR) gives you access to distributed data, enabling you to run
DATATRIEVE interactively on another computer connected to yours by
DECnet. If you are logged on to a PDP-II system, you can run DATATRIEVE on
a PDP-II or VAX system by typing:
RUN $REMDTR

REMDTR prompts you for a node name. Enter the name of a VAX or PDP-II
system with DATATRIEVE installed. REMDTR logs you on to that system, and
you can have an interactive DATATRIEVE session at the remote system.
1.4.8.2 Call Interface - The Call Interface allows you to call the data manage-

ment services ofDATATRIEVE-il from programs in high-level languages such
as BASIC, COBOL, and FORTRAN. You can make calls from a high-level language program to DATATRIEVE services on your local node or on a remote node
or computer connected to your system by DECnet. You do not need DECnet to
make a local call.

1-8

DATATRIEVE-11 Overview

DATATRIEVE-11 Documentation Directory

This chapter describes the elements of the DATATRIEVE-II documentation set
and summarizes the objective, intended audience, and contents of each element.

2.1

DATATRIEVE-11 Installation Guide
Objective

To show how to install DATATRIEVE-I1.
Audience

Those responsible for maintaining the operating system or installing
DATATRIEVE-I1.
Summary

The Installation Guide explains how to install DATATRIEVE-II on different
PDP-II operating systems.

2.2

DATATRIEVE-11 Online Release Notes
Objective

To provide supplemental information about DATATRIEVE-I1.
Audience

All DATATRIEVE-I1 users.
Summary

The online Release Notes that come with your installation kit provide information about the current version ofDATATRIEVE-11 not included in the printed
documentation set.

2-1

2.3

DATATRIEVE-11 Summary Description
Objective

To provide an overview ofDATATRIEVE-II, to briefly explain the utilities for
data management, and to guide users through the documentation set.
Audience

All users ofDATATRIEVE-I1.
Summary

This book offers an overview ofDATATRIEVE-I1. A documentation directory
describes the manuals in the set, a glossary defines terms used in the documentation, and a master index facilitates access to specific concepts and features
throughout the documentation.

2.4

Introduction to DATATRIEVE-11
Objective

To introduce DATATRIEVE to new users.
Audience

People who are unfamiliar with DATATRIEVE. Readers should be able to log in
to a PDP-II computer and display the contents of the default directory. If you
need to review how to do that, consult the user's guide for your operating system.
Summary

The manual begins with a brief overview of information management and then,
using examples, interactively guides you through the basic DATATRIEVE tasks.
These include defining, storing, retrieving, and modifying data and using ADT
and Guide mode.

2.5

DATATRIEVE-11 User's Guide
Objective

To describe the interactive use ofDATATRIEVE-I1.
Audience

People who:
• Are thoroughly familiar with the material covered in the Introduction to
DATATRIEVE-ll
• Have previous experience using DATATRIEVE
• Have experience in application programming but are unfamiliar with
DATATRIEVE

2-2

DATATRIEVE-11 Documentation Directory

Summary

The manual begins by explaining how to set up your DATATRIEVE environment. It then explains how to use the DATATRIEVE-II data dictionaries and
how to use DATATRIEVE to define, retrieve, modify, and restructure data.

2.6

DATATRIEVE-11 Guide to Writing Reports
Objective

To explain how to produce reports using DATATRIEVE-Il.
Audience

Users who want to produce reports based on data managed by DATATRIEVE.
The reader should be familiar with the material covered in the Introduction to
DATATRIEVE-ll and some topics discussed in theDATATRIEVE-ll User's
G~ide.
Summary

The manual begins with examples ofDATATRIEVE-11 reports and then
describes how to write the instructions that specify the format and content of a
report. Subsequent chapters discuss more advanced techniques of report writing.

2.7

DATATRIEVE-11 Call Interface Manual
Objective

To explain how to write high-level language programs that call DATATRIEVE,
and how to use the DATATRIEVE-II Remote Terminal Interface and Call Interface to access data on remote systems as well as the local system.
Audience

Applications programmers who are familiar with DATATRIEVE.
Summary

The manual explains how to call DATATRIEVE-II from within programs written in high-level programming languages such as FORTRAN, COBOL, and
BASIC. It also explains how to use DATATRIEVE to access data on remote
PDP-II and VAX systems.

2.8

DATATRIEVE-11 Reference Manual
Objective

To provide comprehensive reference information about DATATRIEVE-Il.
Audience

Users who have a working knowledge ofDATATRIEVE or know the basic concepts of data processing and are familiar with their operating systems.

DATATRIEVE-11 Documentation Directory

2-3

Summary

The manual explains in detail the rules governing the use of DATATRIEVE-l 1.
It describes value expressions, Boolean expressions, functions, record selection
expressions, and record and field definition clauses. It presents full descriptions
of the commands and statements that compose the DATATRIEVE-ll language.

2.9

DATATRIEVE-11 Pocket Guide
Objective

To provide quick reference information on the syntax and elements of the
DATATRIEVE-ll language.
Audience

Experienced users ofDATATRIEVE.
Summary

The guide lists the formats ofDATATRIEVE-ll commands, statements, clauses,
and value expressions and contains basic information about their use.

2-4

DATATRIEVE-11 Documentation Directory

Glossary

Access control list (ACL)

A table that lists which users are allowed access to the domain, record, procedure, or
table definitions stored in data dictionaries. Each definition in a data dictionary has an
associated ACL. An entry in an ACL consists of:
o A way to identify users

• An access key
• A list of access rights
Application Design Tool (ADT)

. A utility that aids you in creating domains, record definitions, and files by asking you
questions and prompting you for the information.
Arithmetic operator

A symbol used to perform arithmetic operations. DATATRIEVE-ll operators include
addition ( + ), subtraction (-), multiplication (*), and division (I).
Boolean expression

An expression that tells DATATRIEVE how to compare records and what values to use
in the comparison. DATATRIEVE evaluates Boolean expressions as either true or false.
In the statement PRINT PERSONNEL WITH STATUS = "TRAINEE", the expression
STATUS = "TRAINEE" is a Boolean expression.

Glossary-1

Boolean operator

A keyword that enables you to combine or negate Boolean expressions. Boolean operators are AND, OR, NOT, and BUT. For example, the expression STATUS =
"TRAINEE" AND SALARY> 20000 contains the Boolean operator AND.
Call Interface

A DATATRIEVE-ll facility that allows you to call the data: management services of
DATATRIEVE from within a high-level language.
See also Local Call Interface and Remote Call Interface.
Calling program

. A program written in a high-level programming language that uses the data management capabilities ofDATATRIEVE.
Collection

A group of records gathered together from a larger group of records with the FIND
statement. You can name a collection and can have several named collections available
at once.
Column header

The heading that labels a column of data in a report or in the output of a PRINT statement. DATATRIEVE uses the field name as a column header unless the field definition
includes a QUERYJIEADERclause.
Command

A valid combination of words that starts with a DATATRIEVE verb and that deals with
a dictionary or its contents. Examples of commands are: DEFINE, SET, SHOW,
·FINISH, RELEASE, and READY. You cannot join commands or include them in
statements.
See also Statement.
Command file

A file with a default file type .CMD that contains DATATRIEVE commands and statements. You tell DATATRIEVE to execute the commands in the file by typing the at sign
(@) and the file name. DATATRIEVE then displays and executes each statement and
command in the file as though you were entering them.
CURRENT

The keyword that identifies the most recently formed collection.
See also Collection.

Glossary-2

Condition clause

A component ofa record selection expression that tells DATATRIEVE the characteristics of records you want in a record stream. It consists of the word WITH and a Boolean
expression.
Data dictionary

A file that contains information about your data and its organization. DATATRIEVE
automatically connects you to your default dictionary when you enter DATATRIEVE.
To display the name of the dictionary you are using, type SHOW DICTIONARY. To create a data dictionary, use the DEFINE DICTIONARY command. To change your c'urrent dictionary, use the SET DICTIONARY command.
Data file

A set of records stored as a unit on a storage medium, such as a disk. To create a data
file, use the DEFINE FILE command.
See also Indexed file and Sequential file.
Database

Information maintained on a computer and organized to facilitate inquiry and update.
DECnet

The DIGITAL software facility that enables a user to access information on a remote
computer through telecommunications lines. DECnet enables the operating system to
function as a network node.
Detail lines

The formatted data lines that are the output of a Report Writer PRINT statement.
Detail lines contain information from individual records in a report.
Domain

A named data structure that associates a data file and a record definition. Use the
domain name to gain access to information in the data file as interpreted by the record
definition. For example, the domain PERSONNEL associates the file PERSON.DAT
and the record definition PERSONNEL_REC.
Edit string

A character or group of characters that instructs DATATRIEVE to use a specified format to display and print field values.

Glossary-3

Elementary field

A record segment containing one item of information. Elementary fields do not contain
other fields. For example, in an employee record, an elementary field might be the
employee's last name.
See also Field and Group field.
Field

A segment of a record that contains data. A field can consist of a single data item such
as a state abbreviation, or a combination of data items such as a street number and
name. Related fields comprise a record.
See also Elementary field and Group field.
Field definition clause

A phrase that describes the data stored in a record field. The field definition clauses provided by ADT include PIC, USAGE IS, EDIT_STRING, and QUERY_NAME. You can
specify other field definition clauses by using the DEFINE RECORD command.
Field tree

A hierarchical model of the fields in a record, based on the record definition in the data
dictionary. Related fields are stored on the same branch of the tree to make data
retrieval efficient.
File

See Data file.
Group field

A record segment containing one or more elementary or group fields. In the record definition PERSONNEL_REC, the group field NAME contains two elementary fields,
LAST_NAME and FIRST.-NAME.
See also Field and Elementary field.
Guide mode

An interactive tutorial tool. Guide mode helps you work step-by-step through a
DATATRIEVE session and saves you typing time by providing additional prompts and
information as you type in commands and statements. To use Guide mode, type SET
GUIDE.

Glossary-4

Index key

A field that DATATRIEVE uses to locate records in an indexed file. You define the primary index key and any alternate keys in the DEFINE FILE command. You cannot
change the value of a primary index key; however, you can change the values of alternate index keys. For example, a good primary key for the records in a personnel file is
an employee ID number because it uniquely identifies each employee. An example of an
alternate key for the same group of records might be department number.
Indexed file

A file of records in which each record is identified by at least one index key. You can
delete records from an indexed file, but you cannot change the primary index key.
Information management

A process you use to organize and manage information. DATATRIEVE is an information management tool that helps you organize information accurately and efficiently.
Interactive processing

A mode of computer operation in which you control the actions of the computer by entering commands and data at a terminal rather than by using a program. When you communicate with DATATRIEVE, you are using interactive processing.
Keyword

A word that has a specific meaning for DATATRIEVE. Examples of keywords are
DEFINE, SET, and REPORT. The names that you define for domains and tables cannot
exactly match a DATATRIEVE keyword.
Literal

A value expression that is either a character string enclosed in quotation marks or a
number.
Local Call Interface

A Call Interface that allows you to access DATATRIEVE data management services
from within a high-level language program on the same node without using DECnet.
See also Call Interface and Calling program.
Name clause

A component of an RSE that tells DATATRIEVE what to name a record stream.
See also Record selection expression (RSE).

Glossary-5

·.Primary key

The index key whose value determines the order of records in an indexed file. You cannot modify or erase the value in a primary key field.
See also Index key.
Print list

Value expressions such as keywords, symbols, and field names that are used to display
and format record fields. Some Report Writer print list items include SKIP, COL,
SPACE, and (-) and are used to format detail and summary lines in a report.
Privilege

Access to data and data definitions for a specific purpose. There are four privileges to a
definition in a data dictionary: R (read), W (write), M (modify), and E (execute or
extend).
Privileges are defined in the access control list (ACL) for a dictionary definition. Users
must have C (control) privilege to access an ACL.
See also Access control list (ACL).
Procedure

A named sequence of statements and commands that you store in a data dictionary to
perform certain functions. To create a procedure, use the DEFINE PROCEDURE command. To execute a procedure, type a colon (:) and the procedure name. DATATRIEVE
executes a procedure as though you had just typed the commands and statements it
contains.
Prompt

A character or phrase that DATATRIEVE displays on your terminal to let you know it
is waiting for input. The DTR> prompt indicates that you should type in commands and
statements that tell DATATRIEVE what to do next. Other types of prompts, such as
CON>, DFN>, RW>, and Enter, help you know what DATATRIEVE expects from you.
The prompts QED> or IN> appear when you are using the DATATRIEVE Editor.
Prompting expression

An expression you can specify to prompt for input when a statement executes.
Query header

A name that DATATRIEVE uses as a column header when displaying or printing values. You define a column header with the QUERY_HEADER clause. For example,
STATUS is the column header for values from the field EMPLOYEE_STATUS in the
record PERSONNEL_REC.
If you do not use the QUERY_HEADER clause to specify a column header,
DATATRIEVE uses the field name.

Glossary-6

Query name

A synonym for a field name, usually a shorter word. You define a field name synonym
with the QUERY_NAME clause and can use the synonym anywhere you can use the
field name.
Record

A collection of related fields stored as a unit. For example, one employee record may
include an employee's name, address, department, salary, and starting date.
See also Field.
Record definition

A description of record fields that is stored in a data dictionary. A record definition tells
DATATRIEVE how to identify and store information when it accesses a file.
Record selection expression (RSE)

A phrase defining conditions that individual records must meet before they are
retrieved from data files. For example, the statement PRINT PERSONNEL WITH
STATUS = "TRAINEE" contains the record selection expression PERSONNEL WITH
STATUS = "TRAINEE".
Record source

A component of an RSE that tells DATATRIEVE the name of the domain or collection
containing the records you want to include in a record stream.
Record stream

A temporary group of records formed by a record selection expression.
See also Record selection exp!ession (RSE).
Relational operators

Symbols used to compare values. For example, the DATATRIEVE statement FIND
PERSONNEL-WITH SALARY> 10000 contains the relational operator">" (greater
than).
Remote Call Interface

A Call Interface that allows you to access DATATRIEVE data management services on
another node from within a high-level language program. The other node must be connected to your system by DECnet.
See also Call Interface and Calling program.
Remote Terminal Interface (REMDTR)

A program that enables·you to invoke DATATRIEVE on remote PDP-II and VAX systems through DECnet.

Glossary-7

Report header

The heading of a Report Writer report. Some report header options are page number and
date in the top-right corner of the report and a centered title.
Report specification

A series of Report Writer statements that creates and formats a report.
Report Writer

A component ofDATATRIEVE-ll that allows you to create, format, and print reports.
The Report Writer can also include the results of mathematical operations in the report.
Restriction clause

A phrase in a record selection expression that tells DATATRIEVE which records to
include in a record stream.
RSE

See Record selection expression (RSE).
Selected record

The one record in a collection that is available for display or modification without specifying a record selection expression. Use the SELECT statement to indicate a selected
record.
Sequential file

A file whose records are stored and accessed in the order they are written to the file. A
sequential file does not have an index. You cannot delete records from a sequential file.
See also Data file and Indexed file.
Sort key

A field that forms the basis for sorting. For example, in the statement PRINT
PERSONNEL SORTED BY START_DATE, START_DATE is the sort key.
Statement

A valid combination of words starting with a DATATRIEVE verb that performs query,
report, or data manipulation functions. A statement can contain other statements, but
it cannot contain commands.
See also Command.
Statistical functions

Keywords, such as COUNT, AVERAGE, and TOTAL, that tell DATATRIEVE or its
Report Writer to perform a particular calculation.

Glossary-8

Substitution directiv~

An expression in a command or statement passed to DATATRIEVE-11 from a calling
program. The substitution directive is replaced by parameters given in the program.
For example, the program can prompt for the name of a domain and read it in:

READ (St ao) DOMAIN
FORMAT (A)

You pass the name of the domain with the !CMD substitution directive:
CALL DTR$COMMAND (DABt 'READY !CMD't DOMAIN)

Summary line

A line in a report that summarizes information included in the report. Use the AT TOP
and AT BOTTOM statements to create summary lines.
Top-level field

The first field in a record definition. All records have a top-level field that includes all
other fields in the record. The top-level field always has a name and the lowest field
level number (usually 01).
Value expression

A string of symbols that specifies a value for DATATRIEVE to use when executing a
statement. Character-string and numeric literals, arithmetic expressions, qualified field
names, and variables are some of the DATATRIEVE value expressions you can use.
Variable

A value expression created by a DECLARE statement. For example, the following
statement creates a variable, X, which can be assigned any 1- or 2-digit numerical
value:
DECLARE }-{

PIC 99.

View domain

A special type of domain that allows you to include any combination of fields and
records from one or more domains. To users accessing data with a view domain, the
results are the same as if they used a simple domain.
View domains are most useful for:
• Restricting access to sensitive parts of the database
• Making the results of frequently used selections and joins permanent

GlossarY-9

Virtual field

A field that appears in the record definition but not in the physical record. In
DATATRIEVE, you create virtual fields with the COMPUTED BY clause. For example,
you can add the field called WEEKLY_SALARY to PERSONNEL-REC by adding the
following to the record definition:
05 WEEKLY_SALARY

COMPUTED BY SALARY/52
EDIT_STRING IS $$,$$$.

Because the value of a COMPUTED BY field is computed when a statement executes, it
occupies no space in the record.
Workspace

The maximum amount of memory you can use during a DATATRIEVE session. Use the
SHOW SPACE command to display information about your DATATRIEVE workspace.

Glossary-10

Master Index

This index contains entries for the entire DATATRIEVE-ll document set.
Manuals are indicated by the following abbreviations:
INTRO

Introduction to DATATRIEVE-ll

REPORT

Guide to Writing Reports

User's Guide

REF

Reference Manual

CALL

Call Interface Manual

Page numbers followed by a "t" contain tables; those followed by "f' contain
figures. For example, a reference to REF 5-3t would indicate a table on page 5-3
of the Reference Manual.

Master Index

See Colon

<
See LESS_THAN relational operator

>
See GREATER_THAN relational operator
@

See AT sign

A
ABORT statement, REF 5-15 to 5-18
effect of SET ABORT, REF 5-15
in command file, UG 10-,5
in STORE statement, REF 5-217
Aborting commands, DTUNWD, CALL 4-29,
8-25
Aborting procedures, UG 9-12 to 9-13
Access Block, DATATRIEVE
See DATATRIEVE Access Block
Access codes, REF 5-67t
Access control list
access codes, REF 5-67t
adding entries to, UG 19-11
contents, UG 19-1 to 19-6
control (C) privilege, UG 20-2
creating, UG 19-6 to 19-7
creating for ports, REF 5-55
creating for procedures, REF 5-57
creating for records, REF 5-61
creating for RMS domains, REF 5-46
creating for tables, REF 5-64
creating for view domains, REF 5-48
defining entries, REF 5-66 to 5-68
deleting entries, UG 19-11, REF 5-71 to 5-72

November 1987

Access control list (cont.)
displaying, UG 19-10, 20-2, REF 5-209 to
5-210
execute (E) privilege, UG 20-2
key, UG 19-1 to 19-6
lock type, UG 19-1 to 19-6
maintaining, UG 19-9 to 19-11, 20-6
modify (M) privilege, UG 20-2
privileges, UG 19-4 to 19-6
processing, UG 19-7 to 19-9
protecting data, UG 19-1
read (R) privilege, UG 20-2
sample, UG 19-1F
sequence number, UG 19-1 to 19-6
SHOWP command, REF 5-209 to 5-210
write (W) privilege, UG 20-2
Access modes, REF 5-170t
EXTEND, REF 5-170
MODIFY, REF 5-170
READ, REF 5-170
required by DATATRIEVE statements,
REF5-172t
WRITE, REF 5-170
Access options, REF 5-169t
Accessing domains, INTRO 2-4 to 2-5
EXCLUSIVE, REF 5-169
PROTECTED, REF 5-169
READY command, REF 5-169 to 5-174
restrictions, REF 5-170
results, REF 5-171
SHARED, REF 5-169
Accounts
default DECnet, CALL 2-1
specifying to the Remote Terminal Interface,
CALL 2-1

Master Index-1

ACL
See Access control list
ADT
See Application Design Tool
ADT command, INTRO 3-6, ua 10-3,
REF 5-19
See also Application Design Tool
ADVANCED HELP command, ua 2-7
Alias
domain name, REF 5-169
ALIGNED_MAJOR_MINOR allocation,
REF 5-20
ALL
in RSE, REF 3-4
in SHOW command, REF 5-206
print list element, REF 5-158,5-160
Allocating LUNs, CALL 3-9
ALLOCATION clause, ua 6-6, REF
5-20 to 5-22
ALIGNED_MAJOR_MINOR, REF 5-20
in DEFINE FILE command, REF 5-50
in DEFINE RECORD command, REF 5-60
LEFT _RIGHT, REF 5-20
MAJOR_MINOR, REF 5-20
Alphanumeric fields, ua 5-10
edit string characters, REF 5-104 to 5-106
picture string characters, REF 5-156
AND Boolean operator, INTRO 6-5, ua 7-8,
REF 2-20
ANY relational operator, REF 2-19
Application Design Tool, UG 4-1, REF 4-1
defining data with, INTRO 3-1 to 3-9
defining records, ua 5-1
exiting, REF 5-19
invoking', REF 5-19
sample session, INTRO 3-4 to 3-8
use in definitions, REF 1-10
Argument list, CALL 8-7f
Arguments
in procedures, ua 9-4 to 9-5
Arithmetic expressions, REF 2-14 to 2-15
evaluating, REF 2-14
minus sign in, REF 2-14
parentheses in, REF 2-14
valid operators, REF 2-14t
Arithmetic operators, REF 2-14t
ASCENDING
in SORT statement, REF 5-213, 5-223
sort key, INTRO 6-8, REF 3-7
ASCII collating sequence, REF 2-18, 3-8
Assigning query names
using the ADT command, INTRO 3-2

Master Index-2

Assignment statement, ua 11-2, REF
5-23 to 5-30
for elementary fields, REF 5-23 to 5-25
for group fields, REF 5-25 to 5-27
for variables, REF 5-27 to 5-30
Asterisk (*)
edit string character, REF 5-107
AT (@)sign
executing command files, ua 5-3
using to invoke command files, REF
5-13 to 5-14
AT BOTTOM statement (Report Writer), REF
5-186 to 5-188
OF field-name, REPORT 2-17,3-3,3-8 to 3-9
OF PAGE, REPORT 2-17
OF REPORT, REPORT 2-17,2-18, 3-14
summary elements, REF 5-187t
AT TOP statement (Report Writer), REF 5-188
to 5-191
header and summary elements, REF 5-189t
OF field-name, REPORT 3-3
OF PAGE, REPORT 2-17,3-10 to 3-13
OF REPORT, REPORT 2-17
AVERAGE statistical function, REPORT 1-9,
2-17 to 2-18, REF 2-11
in AT BOTTOM statement (RW), REF 5-187
in AT TOP statement (RW), REF 5-189

B
B (blank)
edit string character, REF 5-105
BASIC sample programs, CALL 7-1 to 7-10
BEGIN-END statement, ua 8-3 to 8-6, REF
5-31 to 5-34
declaring variables in, REF 5-39
initializing variables, REF 5-32
invoking procedures from, REF 5-10
restrictions, REF 5-31
results, REF 5-31
usage notes, REF 5-32
with REPEAT statement, REF 5-32
BETWEEN relational operator, INTRO 6-4,
ua 7-6, REF 2-17
Boolean expressions, REF 2-16 to 2-21
Boolean operators, REF 2-20 to 2-21
commas in, REF 3-7
compound, ua 7-8 to 7-9, REF 2-21, 2-21t
defined, REF 2-1
evaluating, REF 2-21
grouping with parentheses, REF 2-21
in RSE, REF 3-6
relational operators, REF 2-17 to 2-20, 2-20t
using, REF 2-16

November 1987

Boolean operators, ua 7-8, REF 2-20 to 2-21
Brackets []
used as syntax prompts, ua 2-5
BT
See BETWEEN relational operator
BUFLEN, parameter to DTINIT, CALL 4-10
BUT Boolean operator, INTRO 6-5, ua 7-8,
REF 2-20

c
Call Interface, ua 1-6, REF 1-12, CALL 1-5,
1-6f
closing, CALL 4-30
creating menus, CALL 1-7
initializing, CALL 4-12,8-15
overview, CALL 4-1
procedures used with, CALL 1-7
tables used with, CALL 1-7
writing programs that use, CALL 4-1 to 4-30
Calls to DATATRIEVE
DTCMD, CALL 4-13, 8-8
DTCONT, CALL 4-24, 4-25, 8-10
DTFINI, CALL 4-30,8-12
DTGETP, CALL 4-23,8-13
DTINIT, CALL 4-12, 8-15
DTLINE, CALL 4-15,8-18
DTMSG, CALL 4-16, 8-19
DTPEOF, CALL 4-25,8-21
DTPUTP, CALL 4-25,8-22
DTPVAL, CALL 4-20,8-24
DTUNWD, CALL 4-29, 8-25
Case sensitivity
with relational operators, ua 7-5
CHANGE, ua 6-8
in DEFINE FILE command, REF 5-51
Character set, REF 1-4
.
Character string literals
See Literals
Characters
edit string, REF 5-102
floating edit string, REF 5-111
picture string, REF 5-156
printing, REF 2-2
Clauses
in procedures, ua 9-4 to 9-5
CLOSE command, REF 5-35
Closing the Call Interface, CALL 4-30
!CMD, substitution directive, CALL 4-14
COBOL sample programs, CALL 6-1 to 6-10
COL
in AT BOTTOM statement (RW), REF 5-187
in AT TOP statement (RW), REF 5-189
print list element, REF 5-160

November 1987

COL (cont.)
RW print list element, REF 5-193
Collections, INTRO 6-11 to 6-21
as record source, REF 3-2
changing content of, INTRO 6-19 to 6-20
CURRENT, REF 3-2
displaying, INTRO 6-11 to 6-12
erasing, INTRO 8-2
establishing with FIND, REF 3-2
forming, INTRO 6-11, REF 5-121 to 5-122
making new CURRENT from old, INTRO
6-14 to 6-15
naming, INTRO 6-15 to 6-17
releasing, INTRO 6-20 to 6-21, REF
5-177 to 5-179
removing records from, REF 5-75 to 5-79
renaming, INTRO 6-18 to 6-19
SHOW command, INTRO 6-14
showing, REF 5-206
showing names of, INTRO 6-17 to 6-18
sorting, INTRO 6-13, REF 5-213 to 5-214
Colon (:)
using to invoke procedures, ua 1-4, REF
5-10 to 5-12
Column headers, REPORT 2-10,2-15 to 2-17
in AT TOP statement (RW), REF 5-189
printing, REF 5-161, 5-162, 5-193
specifying, REPORT 2-16 to 2-17
suppressing, REPORT 2-15, REF 5-161,
5-162, 5-193
wrapping, REPORT 2-13
Column-page setting
See SET COLUMNSYAaE command
COLUMN_HEADER, REPORT 3-12
Comma (,)
edit string character, REF 5-110
Command files, REPORT 2-18 to 2-19, ua 1-4,
10-1 to 10-9
aborting, ua 10-5
comments, ua 10-3, REF 5-14
compared with procedures, ua 10-1
contents, ua 10-3
creating, ua 10-2
creating with EXTRACT, REF 5-118
default file type, REF 5-14
editing, ua 10-5
editing with, ua 16-1
in FOR and REPEAT statements, ua 10-8
in procedures, REF 5-13
invocation command lines, ua 10-4
invoking, ua 10-3 to 10-5, REF 5-13 to 5-14
maintaining, ua 10-8 to 10-9
nesting, ua 10-7 to 10-8
restrictions on invoking, ua 10-4 to 10-5

Master Index-3

Command files (cont.)
sample, UG 10-6 to 10-7
SET ABORT/SET NO ABORT, UG 10-5
stopping execution of, REF 5-15
uses, UG 10-1
Commands and statements, UG 1-3 to 1-4,
REF 1-2 to 1-7
alphabetic summary, REF 5-3t
complex statements, REF 1-3
compound, REF 1-3
continuing, REF 1-6 to 1-7
differences between, REF 1-2
elements of, REF 1-5
functional summary, REF 5-6t
functions of, REF 1-2
in procedures, UG 9-4
in QUERY.lNI file, UG 2-2
nested, REF 1-3
structure of, REF 1-2
syntax, REF 5-1
terminating, REF 1-6 to 1-7
Commands, passing, using DTCMD, CALL
4-13,8-8
Comments, REF 1-7
in command files, REF 5-14
COMP data type, REF 5-229
COMP-l data type, REF 5-229
COMP-2 data type, REF 5-229
COMP-3 data type, REF 5-229
COMP-5 data type, REF 5-230
Compiling programs that call DATATRIEVE,
CALL 3-2
Components ofDATATRIEVE-ll, CALL
1-1 to 1-2
Compound Boolean expressions, REF 2-21
evaluating, REF 2-21t
Compound statements, UG 1-4, 8-1 to 8-6,
REF 1-3
BEGIN-END, UG 8-4 to 8-6, REF
5-31 to 5-34
IF-THEN-ELSE in, UG 8-5
in REPEAT, UG 8-6
in STORE, UG 8-5 to 8-6
FOR in, UG 8-3 to 8-4
BEGIN-END, UG 8-4
REPEAT in, UG 8-1 to 8-3
THEN, REF 5-226 to 5-227
variables in, REF 2-8
Compressing data dictionary, UG 20-4 to 20-6
COMPUTED BY clause, UG 5-1,5-11, REF
5-36 to 5-37
creating virtual fields, REF 2-6, 5-36
in DECLARE statement, REF 5-38
in field definition, REF 4-7

Master Index-4

CON> prompt, UG 2-4, REF 1-8
Concatenated expressions, REPORT 3-4, REF
2-2,2-15 to 2-16
formatting output, REF 2-16
Conditional transfers
with IF-THEN-ELSE statement, REF 1-3
Conserving memory
See Optimizing workspace
CONT
See CONTAINING relational operator
CONTAINING relational operator, INTRO
6-4, UG 7-5, REF 2-17
case-sensitivity, REF 2-18
Context, UG A-I
establishing, UG A-I to A-14
Context block
content of, UG A-2 to A-4
existing collections, UG A-'4 to A-6
global variables, UG A-4
record streams, UG A-5 to A-7
Context stack, UG A-2 to A-8
lasting changes, UG A-6
left
assignment statements, UG A-II
Context variables, UG A-8 to A-II, REF 2-7
field name qualifiers, UG A-8
in FIND statement, REF 3-6
in RSE, REF 3-6
qualifying field names, REF 2-6
with FOR loops, REF 3-6
with MODIFY statement, UG A-13
with STORE statement, UG A-13, REF
5-219
Continuation character, REF 1-6 to 1-7
in character string literals, REF 2-2
Continuation prompt, REF 1-8
Continuing, DTCONT, CALL 4-24, 4-25, 8-10
Control groups, REPORT 3-2 to 3-9
levels of, REPORT 3-4 to 3-8
sort keys, REPORT 3-2 to 3-8
without sort keys, REPORT 3-8
Controlling output, UG 18 .. 1 to 18-5
column width, UG 18-1 to 18-4
Copying domains, CALL 2-3 to 2-4
Corruption of data
protection against, UG 19-1
COUNT statistical function, REPORT 1-9,
2-17 to 2-18, REF 2-11
in AT BOTTOM statement (RW), REF 5-187
in AT TOP statement (RW), REF 5-189
CR (credit)
edit string character, REF 5-109
CREATE DICTIONARY command, UG 20-1
Cross tabulations, REPORT 3-13 to 3-14

November 1987

CTRL/C, va 2-6
with BEGIN-END block, REF 5-32
CTRL/Z, INTRO 2-5, 5-2
exiting from DATATRIEVE, va 2-6, REF
5-116
CURRENT
as target record stream, va A-20 to A-21
in record selection expressions, INTRO 6-15
in SHOW command, REF 5-206

D
DAB
See DATATRIEVE Access Block
DAB fields, CALL 8-5t
DAB$V_BUFFER, CALL 8-15
DAB$V_STRING, CALL 8-6t, 8-8
DAB$W_ERR_CODE, CALL 4-17,8-4,8-19
DAB$W_ERR_SEV, CALL 4-17,8-4,8-19
DAB$W_STR_LEN, CALL 8-6, 8-15
DAB$M_BUF_OVERFLOW flag, CALL 8-18
DAB$M_STR_OVERFLOW flag, CALL 8-6
DAB$V_BUFFER, CALL 8-15
DAB$V_STRING, CALL 8-6t, 8-8
DAB$W_ERR_CODE, CALL 4-17, 8-4
DAB$W_ERR_SEV, CALL 4-17,8-4,8-19
DAB$W_FLAGS, CALL 8-5t
DAB$W_STR_LEN, CALL 8-6, 8-15
Data dictionary, va 1-3
access privileges, va 20-2
changing, va 3-2 to 3-3
contents, va 3-1 to 3-2
creating, INTRO 3-9, va 2-2, 3-2
default extension (.DIC), va 3-2
defining, REF 5-43 to 5-44
deleting, REF 5-69
deleting definitions in, va 20-4
determining size of, VG 20-4
displaying, va 3-3,20-2
editing definitions, va 20-1
extracting from, va 20-6 to 20-7
function, va 3-1
maintaining, va 20-1 to 20-7
modifying, va 20-2 to 20-4
objects, va 20-1
optimizing disk storage, va 20-4 to 20-6
placing definitions into, INTRO 3-8 to 3-9
QCPRS utility, va 20-4
security, va 19-1 to 19-11
setting, va 3-3
showing current, REF 5-44, 5-206
transferring definitions, va 20-1
Data files
See Files

November 1987

Data types, INTRO 3-2 to 3-3
COMP (INTEGER), REF 5-229
COMP-1 (REAL), REF 5-229
COMP-2 (DOUBLE), REF 5-229
COMP-3 (PACKED), REF 5-229
COMP-5 (ZONED), REF 5-230
DATE, REF 5-230
DATATRIEVE
components, va 1-5 to 1-7
concepts and terms, va 1-1 to 1-4
DATATRIEVE Access Block (DAB), CALL 4-1,
4-9t, 8-2, 8-2t
declaring, CALL 4-9
DATATRIEVE states, CALL 4-1, 4-8, 8-3t
list of, CALL 4-8
DATATRIEVE-11, components of, CALL
1-1 to 1-2
Date
arithmetic, REF 2-9
edit string, REF 2-9
suppressing, REPORT 2-10
DATE data type, REF 5-230
Date fields, va 5-11
edit string characters, REF 5-111
DB (debit)
edit string character, REF 5-109
DDMF
See Distributed Server
DDMF.TSK, CALL 1-2
Decimal point (.)
edit string character, REF 5-110
DECLARE PORT statement, REF 5-41 to
5-42, CALL 4-23
DECLARE statement, va 1-3, REF
5-38 to 5-40
in BEGIN-END block, REF 5-31,5-39
variable-name, va 11-1
Declaring variables, va 11-1
DECnet
default accounts, CALL 2-1
node specification, CALL 2-1, 8-l6
using the Remote Call Interface, CALL 1-5
using the Remote Terminal Interface,
CALL 1-3
DECREASING
in SORT statement, REF 5-213,5-223
sort key, REF 3-7
Default dictionary
QUERY.DIC, va 20-1
DEFINE command, va 1-3
DEFINE DICTIONARY command, INTRO
3-9, va 3-2 to 3-3, REF 5-43 to 5-44
DEFINE DOMAIN command, INTRO 3-9, va
1-2,4-1 to 4-2, REF 5-45 to 5-49

Master Index-5

DEFINE DOMAIN command (cont.)
entered interactively, UG 5-2
for RMS domains, REF 5-45 to 5-47
for view domains, REF 5-47 to 5-49
optional password, UG 4-2
syntax, UG 4-2
terminated by semicolon, UG 4-2
usage rules, UG 4-2
DEFINE FILE command, INTRO 3-9, UG 1-2,
6-3 to 6-8, REF 5-50 to 5-54, 5-173
optional clauses, UG 6-6 to 6-8
syntax, UG 6-3
used with sequential files, UG 6-4
DEFINE PORT command, REF 5-55 to 5-56,
CALL 4-22
DEFINE PROCEDURE command, REPORT
1-6, UG 1-4,9-2, REF 5-57 to 5-59
DEFINE RECORD command,INTRO 3-9,
REF 4-1,5-60 to 5-62, 5-173
advantage over ADT, UG 5-1
DEFINE TABLE command, UG 12-3, REF
5-63 to 5-65
DEFINEP command, UG 1-3, REF 5-66 to 5-68
Defining
alternate keys, UG 6-5
data files, REF 5-50 to 5-54
data outside the Application Design Tool,
INTRO 3-9 to 3-10
data with Application Design Tool, INTRO
3-1 to 3-9
dictionaries, REF 5-43 to 5-44
domains, UG 1-2,4-1 to 4-3, REF 1-10,
5-45 to 5-49
RMS, REF 5-45 to 5-47
view, REF 5-47 to 5-49
files, REF 1-10
global variables, REF 2-8
local variables, REF 2-8
ports, REF 5-55 to 5-56
privileges, REF 5-66 to 5-68
procedures, REF 1-7, 5-57 to 5-59
records, UG 5-1 to 5-18, REF 1-10, 4-1 to 4-9,
5-60 to 5-62
tables, REF 1-11, 5-63 to 5-65
Definition prompt, REF 1-8
DELETE command, UG 1-3, 16-5 to 16-6,
REF 5-69 to 5-70
removing data dictionary definition,
UG20-4
terminated by semicolon, UG 20-4
DELETE command (Editor), REF 5-86 to 5-88
DELETEP command, UG 1-3, REF
5-71 to 5-72

Master Index-6

Deleting
dictionaries, REF 5-69
dictionary objects, REF 5-69 to 5-70
domains, REF 5-69
files with SUPERSEDE clause, REF 5-50
procedures, REF 5-69
records, REF 5-69
records in indexed files, REF 5-53
tables, REF 5-69
DESCENDING
in SORT statement, REF 5-213,5-223
sort key, INTRO 6-8, REF 3-7
Detail lines, REPORT 2-10 to 2-17
content, REPORT 2-11 to 2-12
format, REPORT 2-12 to 2-15
DFN> prompt, UG 2-4, REF 1-8
DICTIONARY
in SHOW command, REF 5-206
Dictionary
See Data dictionary
Dictionary objects
controlling access to, UG 19-1 to 19-11
editing, REF 1-11
extracting definitions, REF 5-117
extracting with QXTR, REF 5-119
Dictionary tables
See Tables
Disk space
conserving with QCPRS utility, UG
20-4 to 20-6
DISPLAY statement, REF 5-73 to 5-74
with FILLER fields, REF 4-5
Displaying
DATATRIEVE objects, INTRO 2-4
See also SHOW command
dictionary name, INTRO 2-2
established collections, UG 20-2
readied domains, UG 20-2
Dispiaying reports, REPORT 1-4
Displaying variables, REF 5-40
Distributed Data Manipulation Facility
See Distributed Server
Distributed Server, REF 1-12, CALL 1-2, 1-3,
1-6f
function and use of, UG 1-5 to 1-7
using with the Remote Call Interface, CALL
1-5
Dollar sign ($)
edit string character, REF 5-110
floating edit string character, REF 5-111
Domains
access all records, UG 7-2
accessing, REF 5-169 to 5-174

November 1987

Domains (cont.)
alternative names, REF 5-169
as record source, REF 3-2
copying, CALL 2-3 to 2-4
defining, ua 1-2,3-1,4-1 to 4-3, REF 1-10,
5-45 to 5-49
RMS, REF 5-45 to 5-47
view, REF 5-47 to 5-49
deleting, REF 5-69
editing, REF 5-80 to 5-85
hierarchical, REF 5-148 to 5-151
modifying, REF 5-46
planning, INTRO 3-2 to 3-4
restructuring, ua 15-1 to 15-9
examples, ua 15-2 to 15-9
rules for naming, ua 4-1
sample,INTRO 1-3, ua 2-2
showing, REF 5-207
views, ua 13-1 to 13-9
defining, ua 13-2
DOUBLE data type
See COMP-2 data type
DROP statement, ua 1-3, REF 5-75 to 5-79
DTCLIB.OLB library, CALL 1-2, 1-5,3-9
DTCMD routine, CALL 8-8
format, CALL 4-13
substituting variables with, CALL 4-14
DTCONT routine, CALL 4-24, 4-25, 8-10
DTFINI routine, CALL 4-30,8-12
DTGETP routine, CALL 4-23,8-13
DTINIT routine, CALL 4-10,4-12,8-15
options, CALL 8-16t
DTLINE routine, CALL 4-15,8-18
DTMSG routine, CALL 4-16,8-19
DTPEOF routine, CALL 4-25, 8-21
DTPUTP routine, CALL 4-25, 8-22
DTPVAL routine, CALL 4-20, 8-24
DTR.TSK, ua 1-5, CALL 1-3
DTR> prompt, ua 2-4, REF 1-8
DTUNWD routine, CALL 4-29, 8-25
DUP, Ua6-8
in DEFINE FILE command, REF 5-51

E
EDIT command, ua 1-3, 10-3, REF
5-80 to 5-85
Edit string characters, REF 5-102t
alphanumeric insertion, REF 5-105
alphanumeric replacement, REF 5-104
asterisk (*), REF 5-107
B (space), REF 5-105
comma (,), REF 5-110
CR (credit), REF 5-109

November 1987

Edit string characters (cont.)
date fields, REF 5-111 to 5-113
DB (debit), REF 5-109
decimal point (.), REF 5-110
dollar sign ($), REF 5-110
floating, REF 5-111
floating dollar sign, REF 5-111
floating minus sign, REF 5-111
floating plus sign, REF 5-111
for alphanumeric fields, REF 5-104 to 5-106
hyphen (-), REF 5-105
J (Julian date), REF 5-102
M (month letter), REF 5-102
minus sign (-), REF 5-109
N (month number), REF 5-102
9 (numeric), REF 5-107
numeric fields, REF 5-107 to 5-113
numeric insertion, REF 5-109
numeric replacement, REF 5-107
percent sign (%), REF 5-110
plus sign ( + ), REF 5-109
slash (I), REF 5-105, 5-110
T (text), REF 5-105
W (day letter), REF 5-102
X (alphanumeric), REF 5-104
Y (year), REF 5-102
Z, REF 5-107
zero (0), REF 5-110
Edit strings, REPORT 2-14 to 2-15
date, REF 2-9
for concatenated expressions, REF 2-16
in PRINT statement, REF 5-161
in RW PRINT statement, REF 5-193
text edit strings, REPORT 2-15
EDIT_STRING clause, REF 5-101 to 5-113
in field definition, ua 5-4, REF 4-7 .
Editing dictionary objects, REF 1-11,
5-80 to 5-85, 5-118
Editor, ua 16-1 to 16-14
changing record definitions, ua 5-3
command mode, REF 5-82
commands, ua 16-4 to 16-12
DELETE command, ua 16-5 to 16-6
editing procedures, ua 9-14
ending an editing session, REF 5-82
EXIT command, ua 16-6
IN> prompt, REF 1-8,5-82,5-90
INSERT command, ua 16-6 to 16-8
insert mode, REF 5-82
invoking, ua 16-1 to 16-2
line pointer, ua 16-2
modes, va 16-2
prompts, REF 1-11

Master Index-7

Editor (cont.)
QED> prompt, ua 16-3 to 16-14, REF 1-8,
5-80
QUIT command, ua 16-8
range specifiers, ua 16-3 to 16-4
REPLACE command, ua 16-9 to 16-10
sample editing session, ua 16-13 to 16-14
SUBSTITUTE command, ua 16-10 to 16-11
summary, REF 5-82t
TYPE command, ua 16-11 to 16-12
use of, REF 1-11
using edited definitions, REF 5-84
Editor commands, REF 5-80 to 5-100
DELETE, REF 5-86 to 5-88
EXIT, REF 5-88 to 5-89
INSERT, REF 5-90 to 5-92
QUIT, REF 5-93 to 5-94
range specifiers, REF 5-83t
REPLACE, REF 5-94 to 5-96
SUBSTITUTE, REF 5-96 to 5-98
TYPE, REF 5-99 to 5-100
Elementary fields, REPORT 2-11
alphanumeric, REF 4-6
assigning values to, REF 5-23 to 5-25
COMPUTED BY, REF 4-6
DATE, REF 4-6
defined, ua 5-5 to 5-6, REF 1-9
in field definition, REF 4-2
names, REF 2-3
numeric, REF 4-6
ELSE clause
in DEFINE TABLE command, REF 5-63
EMPLOYEE_REC
valid field names, ua 5-7F
End-of-file marker, passing, DTPEOF, CALL
4-25,8-21
END_PROCEDURE clause, ua 9-2, REF 5-57
END_REPORT statement (Report Writer),
REPORT 1-4, 1-5, 1-7, UG 2-4, REF 5-191
END_TABLE clause, ua 12-3
in DEFINE TABLE command, REF 5-64
Ending a DATATRIEVE session, INTRO 2-5
DTFINI, CALL 4-30, 8-12
EQUAL relational operator, INTRO 6-4, ua
7-4, REF 2-17
Equal sign
in assignment statements, REF 5-23,5-26,
5-28
ERASE statement, ua 1-3, REF 5-114 to
5-115
access mode required, REF 5-172
restrictions, ua 6-2
Erasing data, INTRO 8-1 to 8-3

Master Index-8

Error messages, ua 2-5
incorrectly named fields, ua 5-6
located by a procedure, ua 9-6 to 9-7
retrieving, DTMSG, CALL 4-16,8-19
Error severity codes, DAB$W_ERR_SEV,
CALL 4-17,8-4
Error status codes, DAB$W_ERR_CODE,
CALL 4-17,8-4
Evaluating
arithmetic expressions, REF 2-14
Boolean expressions, REF 2-21, 2-21t
Event Flag Numbers, CALL 3-9
Exclamation point (!), REF 1-7
in command files, REF 5-14
EXCLUSIVE access option, REF 5-169
EXIT command, INTRO 2-5, ua 1-3, 2-6, 16-6,
REF 5-116, CALL 2-2
EXIT command (Editor), REF 5-88 to 5-89
Exiting
an ADT session, INTRO 3-5
DATATRIEVE, INTRO 2-5, ua 2-6
Expressions
arithmetic, REF 2.. 14 to 2-15
Boolean, REF 2-1,2-16 to 2-21
concatenated, REF 2-2, 2-15 to 2-16
DATE value, REF 2-9
evaluating arithmetic, REF 2-14
evaluating Boolean, REF 2-21, 2-21t
prompting value, REF 2-10 to 2-11
statistical, REF 2-11 to 2-13
table values in, REF 2-11
value, REF 2-1 to 2-16
EXTEND access mode, REF 5-170
EXTRACT command, ua 1-3, 9-14, 20-3, REF
5-117 to 5-120, CALL 2-3
copying record definitions, ua 5-3

F
FAMILIES sample domain, ua 2-2
using list field, ua 5-13
using SHOWP, ua 20-2
Field classes, REF 4-6, 4-6t
Field definitions, ua 5-3 to 5-12
clauses, ua 1-2,5-10 to 5-12, REF 4-7 to 4-9,
4-7t
COMP (INTEGER), REF 5-229
COMP-1 (REAL), REF 5-229
COMP-2 (DOUBLE), REF 5-229
COMP-3 (PACKED), REF 5-229
COMP-5 (ZONED), REF 5-230
components of, REF 4-1
EDIT_STRING clause, ua 5-4

November 1987

Field definitions (cont.)
elementary fields, UG 5-5 to 5-6
group fields, UG 5-5 to 5-6
level numbers, UG 5-4 to 5-6
level numbers in, REF 4-2 to 4-3
naming fields, UG 5-6
PICTURE clause, UG 5-4
rules for writing, UG 5-3 to 5-12, REF
4-8 to 4-9
specifying field characteristics, REF 4-7
terminated by period (.), UG 5-4
valid field names, UG 5-7F
word boundary alignment, REF 5-21
Field names
as value expressions, REF 2-3
COMPUTED BY clause, REF 2-6
duplicate, UG 5-7 to 5-8
elementary, REF 2-3
FILLER, UG 5-8 to 5-9, REF 4-4 to 4-5
group, REF 2-4 to 2-5
in AT BOTTOM statement (RW), REF 5-187
in AT TOP statement (RW), REF 5-189
in field definition, REF 4-1,4-3 to 4-5
qualified, REF 2-3 to 2-7
qualifying, REF 3-6
REDEFINES, REF 2-3
restrictions, UG 5-6 to 5-7
rules for, REF 4-3
use of hyphens or underscores, UG 1-2
using as value expressions, REF 2-3
using query names, REF 2-6
Field values
in detail lines, REPORT 2-11 to 2-12
Fields
alphanumeric, UG 5-10
COMPUTED BY, REF 2-6, 5-23, 5-36 to 5-37
Computed by, ua 5-11
data types, INTRO 3-2 to 3-3, REF
5-229 to 5-230
date, UG 5-11, REF 5-230
definition clauses, UG 5-10 to 5-12
PICTURE, UG 5-10
USAGE, UG 5-11 to 5-12
elementary, REF 1-9, 2-3, 4-2
elementary and group, UG 1-2
formatting for output, REF 5-101 to 5-113
formatting storage, REF 5-155 to 5-157,
5-228 to 5-230
group, REF 1-9, 4-2
key, REF 5-51
KEY attributes, REF 5-52t
KEY defaults, REF 5-51t
level numbers of, REF 4-3
list, UG 5-13

November 1987

Fields (cont.)
masking, REF 4-4
multiple occurrences, REF 5-148 to 5-151
naming, UG 5-6
~sing the ADT command, INTRO 3-2
numeric, UG 5-11
query names, INTRO 3-2
redefining, REF 5-175 to 5-176
showing, REF 5-207
size, INTRO 3-3
specifying types of data, UG 5-10 to 5-12
Files
allocating storage, REF 5-20 to 5-22
changing structure of, UG 15-1 to 15-9
closing log, REF 5-35,5-153
comparison of sequential and indexed,
UG 6-2t
creating, REF 5-50 to 5-54
defining, UG 1-2, 6-1 to 6-8, REF 1-10,
5-50 to 5-54
indexed, INTRO 3-3 to 3-4, 7-7, UG
6-1 to 6-8, REF 1-10
criteria for using, UG 6-2
defining, UG 6-4
opening log, REF 5-152
organizing, REF 1-10
sequential, INTRO 3-3 to 3-4, UG 6-1 to 6-7,
REF 1-10
criteria for using, UG 6-2
defining, UG 6-3 to 6-4
with fixed-length records, REF 5-51
FILLER fields, REF 4-4 to 4-5
accessing data in, REF 4-5
as group field name, UG 5-9
defining, REF 5-60
displaying with DISPLAY, REF 4-5
FIND statement, INTRO 6-11, REPORT 2-2,
UG 1-3, REF 5-121 to 5-122
access mode required, REF 5-172
.
context variable in, REF 3-6
FINISH command, INTRO 6-21, REPORT 1-7,
UG 1-3, REF 5-123 to 5-125
releasing domains, REF 5-173
FIRST clause
in SELECT, REF 5-197
FIRST n clause
in RSE, UG 7-3, REF 3-4
Flat records, UG 5-14F
FOR statement, REPORT 3-16, UG 8-3, REF
5-126 to 5-129
controlling PRINT output, REF 5-161
creating target record streams, UG
A-23 to A-25
declaring variables in, REF 5-39

Master Index-9

FOR statement (cont.)
invoking procedures with, REF 5-10
to form record streams, REF 3-3
with STORE statement, REF 5-218
Form feed
trailing, REPORT 2-3
Formatting output
See also Edit string characters
date fields, REF 5-111
default, REPORT 2-2, 2-4
fields, REF 5-101 to 5-113
report header, REPORT 2-7
reports, REPORT 1-4
with PRINT, REF 5-158 to 5-165
with the Report Writer, REF 1-11,5-193
FORTRAN sample programs, CALL
5-1 to 5-22
FROM clause, UG 13-2
in DEFINE DOMAIN command, REF 5-48
Functions
format of statistical, REF 2-12
statistical, REF 2-11 to 2-13
values derived with statistical, REF 2-11t

G
GE
See GREATER-EQUAL relational operator
Global variables, UG 11-4
named in context block, ua A-4
GREATER_EQUAL relational operator,
INTRO 6-4, UG 7-6, REF 2-17
GREATER_THAN relational operator,
INTRO 6-4, UG 7-6, REF 2-17
Group fields, REPORT 2-11
alphanumeric, REF 4-6
as primary key, UG 6-5
assigning values to, REF 5-25 to 5-27
defined, UG 5-5 to 5-6, REF 1-9
in assignment statements, REF 2-4 to 2-5
in field definition, REF 4-2
qualifying, REF 2-6
using FILLER field, UG 5-9
GT
See GREATER_THAN relational operator
Guide Mode, INTRO 4-2 to 4-3, UG 2-3, 2-8
invoking, ua 2-8
using a question mark (?), UG 2-8

H
Halting execution
with ABORT, REF 5-15 to 5-18

Master Index-10

HELP command, INTRO 4-1 to 4-2, ua 1-3,
2-6 to 2-7, REF 5-130 to 5-132
ADVANCED HELP, ua 2-7
Hierarchical domains, REF 5-148 to 5-151
Hierarchical records, REPORT 3-15 to 3-18
Hierarchies, ua 14-1 to 14-12
defining, ua 5-13 to 5-18
eliminating empty print lines, UG 14-9
retrieving values
sublists, UG 14-11 to 14-12
using ALL in nested print lists, UG 14-6
using FIND and SELECT statements,
ua 14-3
using nested RSEs, UG 14-9
using OF rse clause, ua 14-5
with nested FOR loops, UG 14-9
saving space, ua 5-13
using, UG 5-14 to 5-18
Hyphen (-), REPORT 2-15,2-16
as a minus sign, REF 1-4
continuation character, UG 5-6, REF 1-6
conversion to underscore (_), UG 1-2, 4-1,
REF 1-4
edit string character, REF 5-105
in record name, UG 5-3
in string literals, REF 2-2

IF-THEN-ELSE statement, ua 8-5, REF
5-133 to 5-135
using with ABORT statement, REF 5-16
IN relational operator, ua 12-5, REF 2-17,
2-19
IN> prompt, REF 1-8, 1-12,5-82,5-90
Inclusion files, DAB, CALL 4-10
INCREASING
in SORT statement, REF 5-213, 5-223
sort key, REF 3-7
Indexed files, INTRO 3-3 to 3-4, UG 6-1 to 6-8
compared with sequential, UG 6-2t
compressing, UG 20-6
creating, REF 5-51,5-52
defining, ua 6-4
deleting records, REF 5-53
ERASE statement with, INTRO 8-1 to 8-3
KEY field attributes, REF 5-52t
KEY field defaults, REF 5-51t
keys, REF 1-10
modifying, INTRO 7-6 to 7-8
modifying records in, REF 5-53
multikey, UG 6-3
optimizing storage, UG 20-6

November 1987

Information management, INTRO 1-1
Ini tializing
Call Interface, CALL 4-12, 8-15
global variables, REF 5-38
local variables, REF 5-32, 5-39
variables, REF 2-7
Input line prompt, UG 2-4
INSERT command, UG 16-6 to 16-8
INSERT command (Editor), REF 5-90 to 5-92
INTEGER data type
See COMP data type
Interactive DATATRIEVE, UG 1-5, CALL 1-3
Internal storage, REF 5-228 to 5-230
@ (Invoke Command File) Command
See AT
: (Invoke procedure)
See Colon
Invoking
an ADT session, INTRO 3-6
command files, REF 5-13 to 5-14
DATATRIEVE, INTRO 2-1, UG 2-1 to 2-2
procedures, REPORT 1-7, REF 1-7, 5-10 to
5-12,5-58
tables, REF 5-64

J
J (Julian date)
edit string character, REF 5-102

K
KEY clause, UG 6-4
in DEFINE FILE command, REF 5-51
KEY field
attributes, REF 5-52t
defaults, REF 5-51t
duplicate values in, REF 5-51
modifying, REF 5-51
primary, REF 5-51
Keys
accessing dictionary objects, UG 19-2
alternate index, INTRO 3-4
defining alternate keys, UG 6-5
defining key fields
rules for, UG 6-6
duplicate values, INTRO 3-4
primary index, INTRO 3-3
Keywords, REF 1-5

November 1987

L
LAST
in SELECT, REF 5-197
LCDDMF.TSK, CALL 1-2
LE
See LESS-EQUAL relational operator
LEFT_RIGHT allocation, REF 5-20, CALL 2-3
LESS_EQUAL relational operator, INTRO
6-4, UG 7-6, REF 2-17
LESS_THAN relational operator, INTRO 6-4,
UG 7-6, REF 2-17
Letters
in string literals, REF 2-3
in table strings, REF 5-63
treatment of, REF 1-4
treatment with CONTAINING, REF 2-18
Level numbers
in field definition, REF 4-1,4-2 to 4-3
rules for assigning, REF 4-3
valid values, REF 5-61
Line pointer, UG 16-2
Lists, REF 2-19
as record source, REF 3-3
changing length of, UG 5-18
creating with OCCURS FOR, REF 5-48
defining fixed occurrences, UG 5-15 to 5-16
defining variable occurrences, UG
5-16 to 5-17
defining with OCCURS clause, UG 5-13 to
5-18, REF 5-148 to 5-151
modifying, REF 3-4
nesting to form sublists, UG 5-17
printing, REPORT 3-16 to 3-18
Lists, in records
See Hierarchies
Literals, REPORT 2-12, REF 2-2 to 2-3
character string, REF 2-2 to 2-3
hyphens in, REF 2-2
in detail lines, REPORT 2-11
numeric, REF 2-3
printing, REF 5-159
Local Call Interface, CALL 1-1,8-16
Local Server, CALL 1-2
Local variables, UG 11-4 to 11-5
effect on context stack, UG A-7
Lock types, UG 19-2
Log files
closing, REF 5-153
opening, REF 5-152
Logical Unit Numbers
allocating, CALL 3-9, 3-10f

Master Index-11

Loops
ABORT statement in, REF 5-15
FOR statement, REF 1-3, 5-126 to 5-129
REPEAT statement, REF 1-3,5-181
WHILE statement, REF 1-3, 5-233 to 5-234
Lowercase letters
conversion of, REF 1-4
in string literals, REF 2-3
LT
See LESS_THAN relational operator
LUNMAP, area for LUN specification, CALL
3-9
LUNs
See Logical Unit Numbers

M
M (month letter)
edit string character, REF 5-102
MACRO-II assembly language, CALL 8-7
MAJOR_MINOR allocation, REF 5-20,
CALL 2-3
MAX clause, UG 5-18,6-7
in DEFINE FILE command, REF 5-51
MAX statistical function, REPORT 2-18 to
2-19, REF 2-11
in AT BOTTOM statement (RW), REF 5-187
in AT TOP statement (RW), REF 5-189
Memory, conserving
See Optimizing workspace
Menu interface, example, CALL 5-1
Menus
creating with the Call Interface, CALL 1-7
Messages, obtaining, DTMSG, CALL 4-16,
8-19
MIN statistical function, REPORT 2-18 to
2-19, REF 2-11
in AT BOTTOM statement (RW), REF 5-187
in AT TOP statement (RW), REF 5-189
Minus sign ( - )
edit string character, REF 5-109
floating edit string character, REF 5-111
in arithmetic expressions, REF 2-14
MODIFY access mode, REF 5-170
MODIFY statement, UG 1-3, 2-5, REF
5-136 to 5-147
access mode required, REF 5-172
ALL, INTRO 7-8 to 7-9
assigning field values with, REF 5-23,5-26
changing fields, UG 6-2
effect of ABORT statement, REF 5-16
preventing, INTRO 7-5 to 7-6
VERIFY clause, REF 5-217
with lists, REF 3-4

Master Index-12

Modifying
access control list, REF 5-66 to 5-68
data, INTRO 7-1 to 7-10
domains, REF 5-46
key fields, REF 5-51
procedures, REF 5-58
record definitions, REF 5-62
records in indexed files, REF 5-53
records in sequential files, REF 5-53
selected record, INTRO 7-4 to 7-6
tables, REF 5-65

N
N (month number)
edit string character, REF 5.. 102
Names, REF 1-5 to 1-6
continuing, REF 1-6
rules for, REF 1-5
Naming fields
using the ADT command, INTRO 3-2
Naming reports, REPORT 1-4
NE
See NOT.-EQUAL relational operator
NEW_PAGE, REPORT 3-10,3-13
in AT BOTTOM statement (RW), REF 5-187
in AT TOP statement (RW), REF 5-189
print list element, REF 5-160
RW print list element, REF 5-193
NEW_SECTION
in AT BOTTOM statement (RW), REF 5-187
in AT TOP statement (RW), REF 5-189
RW print list element, REF 5-193
NEXT
in SELECT, REF 5-197,5-198
9 (numeric)
edit string character, REF 5-107
picture string character, REF 5-156
NO CHANGE, UG 6-8
in DEFINE FILE command, REF 5-51
NO DUP, UG 6-8
in DEFINE FILE command, REF 5-51
Node specification, CALL 2-1,8-16
NOT BETWEEN relational operator,
REF 2-17
NOT Boolean operator, INTRO 6-5, UG 7-8,
REF 2-20
NOTBT
See NOT BETWEEN relational operator
NOTCONT
See NOT CONTAINING relational operator
NOT CONTAINING relational operator,
REF 2-17
NOT EQUAL relational operator, UG 7-4

November 1987

NOT IN relational operator, ua 12-5,
REF 2-17
NOT_EQUAL relational operator, INTRO 6-4,
REF 2-17
Numeric fields, ua 5-11
edit string characters, REF 5-107 to 5-113
picture string characters, REF 5-156
Numeric literals
See Literals

o
Object module libraries, CALL 3-9
Obtaining messages, DTMSG, CALL 4-16,
8-19
Obtaining print lines, DTLINE, CALL 4-15,
8-18
Obtaining records from DATATRIEVE,
DTGETP, CALL 4-23,8-13
OCCURS clause, REPORT 3-15, ua 5-13 to
5-18, REF 5-148 to 5-151
changing list length, ua 5-18
defining hierarchical records, ua 5-14
fixed number of occurrences, ua 5-15 to
5-16, REF 5-148 to 5-149
in field definition, REF 4-7
variable number of occurrences, ua 5-16 to
5-17, REF 5-150 to 5-151
OCCURS FOR clause, ua 13-2
in DEFINE DOMAIN command, REF 5-48
OF rse clause
targeting record streams, ua A-21 to A-23
OPEN command, REF 5-152 to 5-154
Operators
arithmetic, REF 2-14, 2-14t
Boolean, REF 2-20 to 2-21
relational, REF 2-17 to 2-20, 2-20t
Optimizing
response time, ua 17-6 to 17-9
SHOW SPACE command, REF 5-207
with keyed access, ua 17-6 to 17-9
workspace, ua 17-5
Options, for DTINIT, CALL 8-15, 8-16t
OR Boolean operator, INTRO 6-5, ua 7-8,
REF 2-20
Output
controlling, ua 18-1 to 18-5
default settings, ua 18-1
Overlays, CALL 3-11
OWNERS sample domain, ua 2-2

November 1987

p
P (decimal scaling)
picture string character, REF 5-157
PACKED data type
See COMP-3 data type
Page format, REPORT 2-4 to 2-7
length, REPORT 2-6
width, REPORT 1-6, 2-2, 2-5
Page numbers, REPORT 2-7
suppressing, REPORT 2-10
Parentheses
in arithmetic expressions, REF 2-14
in Boolean expressions, REF 2-21
in statistical expressions, REF 2-12
Passing command lines to DATATRIEVE,
DTCMD, CALL 4-13,8-8
Passing end-of-file marker, DTPEOF, CALL
4-25,8-21
Passing records
from DATATRIEVE, DTGETP, CALL 8-13
to DATATRIEVE, DTPUTP, CALL 4-25,
8-22
Passing values to DATATRIEVE, DTPVAL,
CALL 4-20, 8-24
Passwords
keys, ua 19-2
specifing to the Remote Terminal Interface,
CALL 2-1
Percent sign (%)
edit string character, REF 5-110
Period
in DECLARE statement, REF 5-38
in DEFINE DOMAIN clause, REF 5-48
in DEFINE RECORD command, REF 5-61
in field definition, ua 5-4, REF 4-1
PERSONNEL sample domain, ua 2-2, 2-3
record data items, ua 5-2F
PERSONNEL_REC
record level numbers, ua 5-4
sample record definition, ua 5-2F·
PICTURE clause, ua 5-10, REF 5-155 to
5-157
alphanumeric fields, REF 5-156
in DECLARE statement, REF 5-38
in field definition, ua 5-4, REF 4-7
numeric fields, REF 5-156
restrictions, REF 2-3
Picture string characters
9 (numeric), REF 5-156
P (decimal scaling), REF 5-157
S (sign), REF 5-157
V (decimal point), REF 5-157
X (alphanumeric), REF 5-156

Master Index-13

Plus sign ( +)
edit string character, REF 5-109
floating edit string character, REF 5-111
Pool space
See Workspace
Ports, CALL 4-21, 4-22f, 8-13
declaring temporary, REF 5-41 to 5-42
defining, REF 5-55 to 5-56
global, REF 5-42
local, REF 5-42
Primary index key, INTRO 3-3
Print items
column position of, REPORT 2-13 to 2-14
cross tabulations, REPORT 3-14
edit string format, REPORT 2-14 to 2-15
order of, REPORT 2-13
Print lines, obtaining, DTLINE, CALL 4-15,
8-18
PRINT statement, INTRO 6-1, ua 1-3, REF
5-158 to 5-165
access mode required, REF 5-172
creating reports with, INTRO 9-1
defaults, REF 5-162
displaying data with, INTRO 6-5 to 6-10
lists, ua 14-9
print list elements, REF 5-160t
print list modifiers, REF 5-161t
retrieving data, ua 2-3
PRINT statement (Report Writer), REPORT
1-3, 1-3, 1-4,2-1, REF 5-192 to 5-194
detail lines, REPORT 2-11
order of print items, REPORT 2-13
Privileges
access codes, REF 5-67t
assigning, ua 19-10
defining with DEFINEP, REF 5-66 to 5-68
showing, REF 5-209 to 5-210
Procedures, ua 1-4, 9-1 to 9-16
aborting, ua 9-12 to 9-13
comments in, ua 9-5
compared with command files, ua 10-1
contents, ua 3-1, 9-3 to 9-5
defining, ua 9-1 to 9-2, REF 1-7,
5-57 to 5-59
deleting, ua 9-15 to 9-16, REF 5-69
displaying, ua 9-14
editing, ua 9-14 to 9-15, REF 5-80 to 5-85
for reports, REPORT 2-19
in compound statements, ua 9-10 to 9-12
including command files in, REF 5-13
invoking, ua 9-2 to 9-3, REF 1-7, 5-10 to
5-12,5-58
locating errors, ua 9-5 to 9-7
maintaining, ua 9-13 to 9-16

Master I ndex-14

Procedures (cont.)
modifying, REF 5-58
nesting, ua 9-8 to 9-10, REF 5-10
REPEAT statements in, REF 5-182
samples, ua 9-7 to 9-8
SET ABORT/SET NO ABORT, ua
9-12 to 9-13
showing, REF 5-207
stopping execution of, REF 5-15
using with the Call Interface, CALL 1-7
Prompting expressions, CALL 4-20
Prompting value expressions, REPORT 1-6 to
1-7,2-12, REF 2-10 to 2-11
as print item, REPORT 2-11
for page width, REPORT 2-5
for report length, REPORT 2-6
for storing and modifying values, ua 2-5,
REF 1-9
for syntax, REF 1-9
forming, REF 2-10
in Boolean expressions, REF 2-18
in loops, REF 2-10
Prompts, REF 1-8 to 1-9
CON>, ua 2-4,REF 1-8
DFN>, ua 2-4, REF 1-8
DTR>, ua 2-4, REF 1-8
IN>, REF 1-8, 1-12,5-82,5-90
QED>, REF 1-8,1-11,5-80
REMDTR>, REF 1-12
RW>, REPORT 1-5, ua 2-4, REF 1-8
syntax, ua 2-5
PROTECTED access option, REF 5-169
Protecting dictionary tables, ua 12-9

Q
QCPRS utility
conserving disk space, ua 20-4 to 20-6
data dictionary compression, ua 20-4
defaults, ua 20-5
improving performance, ua 20-4
invoked by Digital Command Language,
ua 20-5
QED> prompt, ua 16-3 to 16-14, REF 1-8,
1-11,5-80
Qualified field names, REF 2-6
Query names, INTRO 3-2
specifying, ua 5-12
using, REF 2-6
QUERY.DIC default dictionary, ua 20-1
QUERY.lNI file, ua 2-2
sample, ua 2-3
SET DICTIONARY in, ua 2-3
SET GUIDE in, ua 2-3

November 1987

QUERY_HEADER clause, ua 5-10, REF
5-166 to 5-167
in field definition, REF 4-4,4-7
QUERY_NAME clause, ua 5-10, REF 5-168
in field definition, REF 4-4,4-7
Question mark (?)
used in Guide mode, ua 2-8
QUIT command, ua 16-8
QUIT command (Editor), REF 5-93 to 5-94
Quotation marks
around string literals, REF 2-2
QXTR utility, ua 20-6 to 20-7, REF 5-119
creating command files, ua 20-6
transferring data dictionary objects,
Ua20-6

R
Range specifiers
in editing commands, REF 5-83t
READ access mode, REF 5-170
READY
in SHOW command, REF 5-207
READY command, INTRO 2-4 to 2-5,
REPORT 2-2, REF 5-169 to 5-174
gaining access to domains, ua 1-3
retrieving data, ua 2-3
with PRINT statement, REF 5-159
REAL data type
See COMP-l data type
Record definition
changing, ua 15-1 to 15-9
contents, ua 3-1
field definitions within, ua 5-3 to 5-12
modifying, REF 5-62
OCCURS clause, REF 5-148 to 5-151
PICTURE clause, REF 5-155 to 5-157
QUERY_HEADER clause, REF
5-166 to 5-167
QUERY_NAME clause, REF 5-168
REDEFINES clause, REF 5-175 to 5-176
SIGN clause, REF 5-211 to 5-212
steps in writing, ua 5-1 to 5-18
using OCCURS clause, ua 5-14
VALID IF clause, ua A-8, REF
5-231 to 5-232
Record names
qualifying, REF 2-6
Record selection expression, INTRO 6-2 to 6-5,
ua 7-1 to 7-10
accessing records, ua 7-2
ALL clause, ua 7-2, REF 3-4
Boolean expressions, ua 7-4 to 7-6
context variable in, REF 3-6

November 1987

Record selection expression (cont.)
definition, ua 7-1
FIRST n clause, ua 7-1 to 7-3, REF 3-4
format, REF 3-1
limiting the number, ua 7-3
record source, REF 3-2 to 3-4
retrieving field values, ua 5-8
SORTED BY clause, ua 7-1,7-9 to 7-10,
REF 3-5, 3-7
tables, UG 7-7
WITH clause, ua 7-1,7-4 to 7-9, REF 3-6
record selection expression
tables, UG 12-5
Record stream, INTRO 6-1, ua 7-1
displaying fields, INTRO 6-9 to 6-10
erasing, INTRO 8-2, 8-3
forming, INTRO 6-2 to 6-5, REF 3-1
from collections, REF 3-2
from domains, REF 3-2
from lists, REF 3-3
limiting, INTRO 6-2 to 6-6
modifying fields, INTRO 7-9 to 7-10
modifying records in, INTR 0 7-9 to 7-10
naming, REF 3-6
sorting, INTRO 6-6 to 6-9, REF 3-7
by field values, ua 7-9 to 7-10
specifying conditions, REF 3-6
specifying number, REF 3-4
stopping display, INTRO 6-10
Record streams
context block, ua A-5 to A-7
Records
comparing, ua 7-4 to 7-6
components of, REF 1-9
defining, ua 1-2,5-1 to 5-18, REF 1-10,
4-1 to 4-9,5-60 to 5-62
field definitions within, ua 5-3 to 5-12
field level numbers, ua 5-4 to 5-6
specifying names, ua 5-2 to 5-3
with variable length list, ua 5-16 to 5-17
deleting, ua 6-2, REF 5-69
editing, REF 5-80 to 5-85
establishing a single record context,
REF 5-198
example data items, ua 5-2f
fiat, ua 5-14f
forming streams, REF 3-1
grouping
by table reference, ua 7-7
in range of values, ua 7-6 to 7-7
hierarchical, ua 5-14 to 5-18, REF 2-19
limiting access, ua 13-3
limiting fields in a, ua 13-3
logical, REF 4-1

Master Index-15

Records (cont.)
modifying, UG 6-2
passing to DATATRIEVE, DTPUTP,
CALL 4-25, 8-22
removing from collections, REF 5-75 to 5-79
retrieving from DATATRIEVE, DTGETP,
CALL 4-23,8-13
rules for naming, UG 5-3
sample definition, UG 5-2f
selecting, REF 5-197 to 5-201
conditional expressions, UG 7-4
showing, REF 5-207
sorting, REF 5-213 to 5-214
storing, REF 5-215 to 5-222
transferring, CALL 4-21 to 4-29
with missing values, INTRO 5-3
REDEFINE command, REF 5-174.1
changing domain definitions, UG
15-2 to 15-9
REDEFINES clause, UG 5-10, REF
5-175 to 5-176
in field definition, REF 4-7
Redefining objects
See REDEFINE command, REF 5-174.1
Relational operators, INTRO 6-4t, UG 7-4 to
7-8, REF 2-17 to 2-20, 2-20t
summary of, UG 7-7T
RELEASE command, INTRO 6-20, UG 1-3,
REF 5-177 to 5-179
Releasing
domains and collections, REF 5-123 to 5-125
global variables, REF 5-39,5-40
local variables, REF 5-39
REMDTR, CALL 1-2, 1-3
Remote Access Interface, REF 1-12
Remote Call Interface
See Call Interface
Remote Terminal Interface, UG 1-6 to 1-7,
REF 1-12, CALL 1-1, 1-2
advantages of, CALL 1-4
copying domains, CALL 2-3 to 2-4
example, CALL 2-1, 2-2, 2-4
exiting, CALL 2-2
invoking, CALL 2-1
prompt, REF 1-12
specifying a node, CALL 2-1
specifying an account, CALL 2-1
testing DATATRIEVE, CALL 2-2 to 2-3
using REMDTR, CALL 1-3
REPEAT statement, UG 8-1 to 8-3, REF
5-180 to 5-182
BEGIN-END statement in, REF 5-32
declaring variables in, REF 5-39
invoking procedures with, REF 5-10

Master Index-16

REPEAT statement (cont.)
nesting in procedures, REF 5-182
with STORE statement, REF 5-217
REPLACE command, UG 16-9 to 16-10
REPLACE command (Editor), REF 5-94 to
5-96
Report header, REPORT 2-7 to 2-10
REPORT statement, REPORT 1-4, 1-5,2-1,
2-2 to 2-3, UG 1-3, REF 5-183 to 5-186
access mode required, REF 5-172
identifying data, REPORT 2-2
retrieving data, UG 2-3 to 2-4
selecting output medium, REPORT
2-19 to 2-21
default, REPORT 2-20
file, REPORT 2-20
printer, REPORT 2-20
prompt option, REPORT 2-20
terminal, REPORT 2-20
Report Writer, REF 1-11
AT BOTTOM statement, REF 5-186 to 5-188
AT BOTTOM statement summary elements,
REF 5-187t
AT TOP statement, REF 5-188 to 5-191
AT TOP statement header and summary
elements, REF 5-189t
invoking, REPORT 1-5, 2-2 to 2-3, REF
5-183 to 5-186
print list elements, REF 5-193t
print list modifiers, REF 5-193t
PRINT statement, REF 5-192 to 5-194
prompt, REF 1-8
SET statement, REF 5-194. to 5-196
REPORT_HEADER, REPORT 3-12,3-13
in AT TOP statement (RW), REF 5-189
Reports, INTRO 9-1 to 9-6
cross tabulations, REPORT 3-13 to 3-14
dating, REPORT 2-7, 2-9
designing, REPORT 2-1 to 2-21
general features, INTRO 9-1 to 9-2
hierarchical records, REPORT 3-15 to 3-16
naming, REPORT 2-1,2-7
output to disk file, INTRO 9-5
output to line printer, INTRO 9-5
page numbers, REPORT 2-7
periodic, REPORT 1-1
print list options, INTRO 9-5
query, REPORT 1-1
sample, REPORT 1-2
saving specifications, INTRO 9-6
special page headings, REPORT 3-12 to 3-13
specification, INTRa 9-2 to 9-5, REPORT
1-4 to 1-5,2-1 to 2-2
title page, REPORT 3-10 to 3-12

November 1987

Reports (cont.)
writing, REF 5-183 to 5-186
Response time
reducing with QCPRS utility, va 20-4
Restructuring domains
examples, va 15-1 to 15-9
Retrieving data, INTRO 6-1 to 6-21, va
2-3 to 2-4
displaying all records, INTRO 6-1
Retrieving messages, DTMSG, CALL 4-16,
8-19
Retrieving print lines, DTLINE, CALL 4-15,
8-18
Retrieving records from DATATRIEVE,
DTGETP, CALL 4-23, 8-13
RETURN key, REF 1-6
RMSdomains
defining, REF 5-45 to 5-47
RMS facility
capabilities, va 6-1 to 6-3
Routines, CALL 8-7 to 8-25
DTCMD, CALL 4-13,8-8
DTCONT, CALL 4-24, 4-25, 8-10
DTFINI, CALL 4-30, 8-12
DTGETP, CALL 4-23, 8-13
DTINIT, CALL 4-12, 8-15
DTLINE, CALL 4-15,8-18
DTMSG, CALL 4-16,8-19
DTPEOF, CALL 4-25, 8-21
DTPUTP, CALL 4-25, 8-22
DTPVAL, CALL 4-20, 8-24
DTUNWD, CALL 4-29, 8-25
RSE
See Record selection expression
Running programs that call DATATRIEVE,
CALL 3-1 to 3-11
RW> prompt, va 2-4, REF 1-8

s
S (sign)
picture string characters, REF 5-157
Sample editing session, va 16-13 to 16-14
Sample report, REPORT 1-2
Saving reports
using command files, REPORT 1-7 to 1-8
using procedures, REPORT 1-6 to 1-7
Security
dictionary definitions, va 19-1 to 19-11
SELECT statement,INTRO 7-1 to 7-5, REF
5-197 to 5-201
forms of, INTRO 7-2 to 7-3
SliOW command with, INTRO 7-3 to 7-4
with DROP statement, REF 5-198

November 1987

Semicolon, REF 1-6
in DECLARE PORT statement, REF 5-41
in DEFINE DOMAIN clause, REF 5-48
in DEFINE PORT command, REF 5-55
in DEFINE RECORD command, REF 5-61
in DELETE command, REF 5-69
in domain definition, REF 5-46
with DEFINE DOMAIN command, va 4-2
with DELETE command, va 20-4
Sequence numbers, va 19-2
Sequential files, INTRO 3-3 to 3-4, va 6-1 to
6-7, REF 1-10
compared with indexed, va 6-2T
creating, REF 5-51, 5-52
defining, ua 6-3 to 6-4
MODIFY statement with, INTRO 8-3
modifying, INTRO 7-1 to 7-6
modifying records in, REF 5-53
SET ABORT command, va 10-5, 18-4,
REF 5-202, 5-204
effect on ABORT statement, va 18-4, REF
5-15
with REPEAT statement, REF 5-181
SET COLUMNS_PAGE command, va 18-1 to
18-4, REF 5-202, 5-204
SET command, REF 5-202 to 5-205
terminal control, va 1-3
SET DICTIONARY command, va 3-3, REF
5-203,5-204
in QUERY.lNI file, va 2-3
SET GUIDE command, INTRO 4-2, va 2-8,
10-3, REF 5-203
in QUERY.lNI file, va 2-3
SET NO ABORT command, va 10-5, REF
5-202, 5-204
SET NO PROMPT command, REPORT 1-3,
REF 5-203
SET PROMPT command, va 18-4 to 18-5,
REF 5-203
SET statement (Report Writer), REPORT 1-4,
REF 5-194 to 5-196
COLUMNS_PAGE, INTRO 9-3, REPORT
2-2, 2-5, REF 5-194
DATE, REPORT 2-9, REF 5-196
LINES_PAGE, REPORT 2-5 to 2-6,
REF 5-194
MAX_LINES, REPORT 2-6 to 2-7,
REF 5-194
MAX_PAGES, REPORT 2-6 to 2-7,
REF 5-194
NO DATE, REPORT 2-10
NO NUMBER, REPORT 2-10
NUMBER, REF 5-196

Master Index-17

SET statement (Report Writer) (cont.)
REPORT_NAME, REPORT 2-2, 2-7,
2-7 to 2-9, REF 5-196
SET TERMINAL command, UG 18-1
SETUP.DTR command, INTRO 2-2
Severity codes, DAB$W_ERR_SEV, CALL
4-17,8-4
SHARED access option, REF 5-169
SHOW ALL command, INTRO 2-3, UG 20-2,
REF 5-206
SHOW COLLECTIONS command, REF 5-178,
5-206
SHOW command, UG 1-3,2-2, REF 5-199,
5-206 to 5-208
with domains, UG 4-3
SHOW CURRENT command, REF 5-206
SHOW DICTIONARY command, INTRO 2-2,
UG 3-2 to 3-3, REF 5-206
SHOW DOMAINS command, INTRO 2-4,
REF 5-207
SHOW FIELDS command, REPORT 1-5,
REF 5-178, 5-207
SHOW PROCEDURES command, REF 5-207
SHOW READY command, INTRO 2-4,
REF 5-172, 5-178, 5-207
SHOW RECORDS command, INTRO 2-4,
REF 5-207
SHOW SPACE command, REF 5-207
SHOW TABLES command, UG 12-7,
REF 5-207
SHOWP command, UG 1-3, REF
5-209 to 5-210
SIGN clause, UG 5-10, REF 5-211 to 5-212
in field definition, REF 4-7
LEADING, REF 5-211
SEPARATE, REF 5-211
TRAILING, REF 5-211
Single record context, UG A-14
SKIP
in AT BOTTOM statement (RW), REF 5-187
in AT TOP statement (RW), REF 5-189
print list element, REF 5-160
RW print list element, REF 5-193
Slash (I), REPORT 2-8, 2-16
edit string character, REF 5-105,5-110
Sort keys, INTRO 6-7, REPORT 3-2 to 3-8
ASCENDING, REF 3-7
DESCENDING, REF 3-7
in SORT statement, REF 5-213
in SUM statement, REF 5-223
multiple, REPORT 3-4, REF 3-8
SORT statement, UG 1-3, REF 5-213 to 5-214
access mode required, REF 5-172
ASCENDING order, REF 5-213,5-223

Master Index-18

SORT statement (cont.)
DECREASING order, REF 5-213,5-223
DESCENDING order, REF 5-213, 5-223
INCREASING order, REF 5-213,5-223
SORTED BY clause, REPORT 3-2 to 3-8,
UG 7-9 to 7-10
format, REF 3-7
in RSE, REF 3-7
sort keys, REF 3-7
SPACE, REPORT 2-13,2-14
in AT BOTTOM statement (RW), REF 5-187
in AT TOP statement (RW), REF 5-189
in SHOW command, REF 5-207
print list element, REF 5-160
RW print list element, REF 5-193
Special page headings, REPORT 3-12 to 3-13
Specifying domain names
DEFINE DOMAIN command, UG 4-1 to 4-2
Specifying ranges
in editing commands, REF 5-83
Stall points
see States
Starting
an ADT session, INTRO 3-6
DATATRIEVE, INTRO 2-1 to 2-4
Startup banner, UG 2-1
Statements
See Commands and statements
States, DATATRIEVE, CALL 4-1, 4-8, 8-3t
Statistical expressions, REF 2-11 to 2-13
RSE in, REF 2-13
Statistical functions, REPORT 1-8 to 1-9, 2-12,
2-17 to 2-19, REF 2-11t
AVERAGE, REPORT 1-8, 2-17
COUNT, REPORT 1-8, 2-17
MAX, REPORT 1-8, 2-18
MIN, REPORT 1-8, 2-18
TOTAL, REPORT 1-8, 2-17
Status code, DAB$W_ERR_CODE, CALL
4-17,8-4
Stopping command execution, DTUNWD,
CALL 4-29,8-25
STORE statement, INTRO 5-1 to 5-5, UG 1-3,
2-5, REF 5-215 to 5-222
access mode required, REF 5-172
assigning field values with, REF 5-23,5-26
cancelling, INTRO 5-2
data types, INTRO 5-4
effect of ABORT statement, REF 5-16
in FOR statement, REF 5-218
prompts, REF 5-216
REPEATwith,INTRO 5-3
using, to store into a port, CALL 4-23
VERIFY clause, REF 5-217

November 1987

STRLEN, parameter to DTINIT, CALL 4-10
Sublists, ua 5-17
retrieving values, ua 14-11 to 14-12
SUBSTITUTE command, ua 16-10 to 16-11
SUBSTITUTE command (Editor), REF
5-96 to 5-98
Substitution directive (!CMD), CALL 4-14, 8-8
SUM statement, REPORT 1-3,1-3 to 1-4,
ua 1-3, REF 5-223 to 5-225
access mode required, REF 5-172
Summaries
group, REPORT 3-8 to 3-9
Summarizing data, REPORT 2-17 to 2-19
Summary lines, REPORT 1-8 to 1-9,
2-17 to 2-19
Summary statistics, REPORT 1-8 to 1-9
SUPERSEDE clause, ua 6-7
in DEFINE FILE command, REF 5-50
Syntax
commands and statements, REF 5-1
keywords in, REF 1-5
symbols and conventions, REF 5-3, 5-2t
System security
using access control lists, ua 19-1 to 19-11

T
T (text)
edit string character, REPORT 2-15,
REF 5-105
TAB
in AT BOTTOM statement (RW), REF 5-187
in AT TOP statement (RW), REF 5-189
print list element, REF 5-160
RW print list element, REF 5-193
Tables, ua 12-1 to 12-9
and workspace, ua 12-7
code/translation strings, ua 1-4, 12-1 to
12-6, REF 5-63
comparing with IN, REF 2-19
creating, ua 12-3 to 12-4
default edit string, REF 5-64
defining, ua 3-1, REF 1-11, 5-63 to 5-65
defining and using, ua 12-4
deleting, ua 12-9, REF 5-69
displaying, ua 12-7
editing, ua 12-3 to 12-4, 12-8, REF
5-80 to 5-85
functions and uses of, ua 1-4, REF 1-11
IF-THEN-ELSE statement, ua 12-5 to 12-6
in a record selection expression, ua 12-5
in value expressions, REF 2-11
invoking, REF 5-64
maintaining, ua 12-9

November 1987

Tables (cont.)
modifying, REF 5-65
protecting, ua 12-9
releasing, REF 5-177 to 5-179
retrieving values with VIA, REF 2-11
sample, ua 12-1 to 12-2
showing, REF 5-207
using IN relational operator, ua 12-4
using with the Call Interface, CALL 1-7
VALID IF clause, ua 12-6
validating data, ua 12-6
VIA value expression, ua 12-6 to 12-7
WITH in, ua 12-5
Task Builder
using, with Callable DATATRIEVE, CALL
3-3 to 3-7
Task size, reducing
See Optimizing workspace
Terminal Interface
See Remote Terminal Interface
Termination characters, REF 1-6 to 1-7
RETURN key, REF 1-6
semicolon, REF 1-6
THEN statement, REF 5-226 to 5-227
TI
for output to terminal, REPORT 2-20
Title page, REPORT 3-10
TODAY value expression, REF 2-9
TOTAL statistical function, REPORT 2-17 to
2-18, REF 2-11
in AT BOTTOM statement (RW), REF 5-187
in AT TOP statement (RW), REF 5-189
Totals
SUM statement, REF 5-224
Transferring control
with ABORT, REF 5-15
Transferring data, CALL 4-15 to 4-29
Transferring records, CALL 4-21 to 4-29
Transfers
with IF-THEN-ELSE statement, REF 1-3
TYPE command, ua 16-11 to 16-12
TYPE command (Editor), REF 5-99 to 5-100

U
UIC
See User identification code
Underscore (_), ua 1-2, 4-1, REF 1-4
in record name, ua 5-3
UNITS Task Builder qualifier, CALL 3-10
Unwinding, DTUNWD, CALL 4-29, 8-25
Uppercase letters
in string literals, REF 2-3

Master Index-19

USAGE clause, UG 5-10, 5-11 to 5-12, REF
5-228 to 5-230
COMP data type, REF 5-229
COMP-1 data type, REF 5-229
COMP-2 data type, REF 5-229
COMP-3 data type, REF 5-229
COMP-5 data type, REF 5-230
DATE, REF 5-230
in DECLARE statement, REF 5-38
in field definition, REF 4-7
User identification code, ua 3-3
keys, UG 19-2 to 19-3
USING clause, REPORT 2-12, 2-14 to 2-15
in PRINT statement, REF 5-161
in RW PRINT statement, REF 5-193
in STORE statement, REF 5-215

v
V (decimal point)
picture string character, REF 5-157
VALID IF clause, ua 5-10, REF 5-24,5-28,
5-231 to 5-232
in field definition, REF 4-7
in record definition, ua A-8
Value expressions
concatenated, REF 2-15 to 2-16
DATE, REF 2-9 to 2-10
defined, REF 2-1
displaying, REF 5-73 to 5-74
global variables in, REF 2-8
in arithmetic expressions, REF 2-14 to 2-15
in AT BOTTOM statement (RW), REF 5-187
in AT TOP statement (RW), REF 5-189
in detail lines, REPORT 2-11,2-12
local variables in, REF 2-8
prompting, REPORT 1-6 to 1-7, REF
2-10 to 2-11
statistical, REF 2-11 to 2-13
table, REF 2-11
TODAY, REF 2-9
types of, REF 2-1
use of, REF 2-1
variables in, REF 2-7 to 2-9
Variables, REPORT 2-12, UG 11-1 to 11-9
as counters, ua 11-6 to 11-9
assigning values to, REF 5-27 to 5-30, 5-39
context, REF 2-6
declaring, ua 11-1, REF 2-7,5-38 to 5-40
defining global, REF 2-8, 5-38
defining local, REF 2-8,5-31
displaying with SHOW FIELDS, REF 5-40
formatting for output, REF 5-101 to 5-113
global, ua 11-4

Master Index-20

Variables (cont.)
in detail lines, REPORT 2-11
in value expressions, REF 2-7 to 2-9
ini tializing, REF 2-7
initializing global, REF 5-38
initializing local, REF 5-32
local, ua 11-4 to 11-5
releasing global, REF 2-8, 5-40,
5-177 to 5-179
storing values, ua 11-2 to 11-6
VERIFY clause
in MODIFY statement, REF 5-217
in STORE statement, UG A-8, REF 5-215,
5-217, 5-220
VIA clause, REF 2-11, 5-64
VIA value expression, ua 12-6 to 12-7
View domains, ua 13-1 to 13-9
combining data, UG 13-4 to 13-5
containing a list, UG 13-7 to 13-9
defining, ua 13-2, REF 5-47 to 5-49
limiting record access, ua 13-3
Virtual fields
See COMPUTED BY clause

w
W (day letter)
edit string character, REF 5-102
WHILE statement, ua 11-9, REF
5-233 to 5-234
with STORE statement, REF 5-220
WITH clause
in RSE, REF 3-6
Workspace, UG 12-7
defined, ua 17-1
optimizing use of, ua 17-5
WRITE access mode, REF 5-170

x
X (alphanumeric)
edit string character, REF 5-104
picture string character, REF 5-156

v
Y (year)
edit string character, REF 5-102
YACHTS sample domain, ua 2-2, 2-4
access all records, ua 7-2
comparing records, ua 7-4 to. 7-6
SET COLUMNS_PAGE command,
UG 18-2 to 18-4

November 1987

z
Z
edit string character, REF 5-107
Zero (0)
edit string character, REF 5-110
ZONED data type
See COMP-5 data type

November 1987

Master Index-21

How to Order Additional Documentation
If you live in:

Call:

or Write:

New Hampshire,
Alaska

603-884-6660

Digital Equipment Corp.
P.O. Box CS2008
Nashua, NH 03061-2698

Continental USA,
Puerto Rico, Hawaii

1-800-258-1710

Same as above.

Canada
(Ottawa-Hull)

613-234-7726

Digital Equipment Corp.
940 Belfast Road
Ottawa, Ontario K1G 4C2
Attn: P&SG Business
Manager or approved
distributor

Canada
(British Columbia)

1-800-267-6146

Same as above.

Canada
(All other)

112-800-267 -6146

Same as above.

All other areas

Digital Equipment Corp.
Peripherals & Supplies
Centers
P&SG Business Manager
c/o DIGITAL's local
subsidiary

Note: Place prepaid orders from Puerto Rico with the local DIGITAL subsidiary (phone 809-754-7575).
Place internal orders with the Software Distribution Center, Digital Drive,
Westminster, MA 01473-0471.

Reader's Comments

DATATRIEVE,.11
Summary Description
AA-U052B-TC

Please use this postage-paid form to comment on this manual. If you require a written reply to a software
problem and are eligible to receive one under Software Performance Report (SPR) service, submit your
comments on an SPR form.
Thank you for your assistance.

I rate this manual's:
Accuracy (spftware works as manual says)
Completeness (enough information)
Clarity (easy to understand)
Organization (structure of subject matter)
Figures (useful)
Examples (useful)
Index (ability to find topic)
Page layout (easy to find information)

Excellent

Good

Fair

Poor

D
D
D
D
D
D
D
D

I would like to see more/less

What I like best about this manual is

What I like least about this manual is

I found the following errors in this manual:
Page

Description

Additional comments or suggestions to improve this manual:

I am using Version _ _ _ of the software this manual describes.

Name/Title

Dept.

Company

Date

Mailing Address
Phone

I
I
I
I

Do Not Tear - Fold Here and Tape

-------------------nlllr-------;~;;~---1
II

if Mailed
in the
United States

I
I
I

BUSINESS REPLY MAIL
FIRST CLASS PERMIT NO. 33 MAYNARD MASS.
POST AGE WILL BE PAID BY ADDRESSEE

DIGITAL EQUIPMENT CORPORATION

Corporate User Publications-Spit Brook
ZK01-3/J35
110 SPIT BROOK ROAD
NASHUA, NH 03062-9987

111'111111.11'11.1111111.11.1111.1111 •• 1.1 ••• 1.1111 1
-

Do Not Tear - Fold Here

Reader's Comments

DATATRIEVE-11
Summary Description
AA-U052B- TC

I rate this manual's:
Accuracy (software works as manual says)
Completeness (enough information)
Clarity (easy to understand)
Organization (structure of subject matter)
Figures (useful)
Examples (useful)
Index (ability to find topic)
Page layout (easy to find information)

Excellent

Good

Fair

Poor

D
D
D
D
D
D
D
D

I would like to see more/less

What I like best about this manual is

What I like least about this manual is

I found the following errors in this manual:
Page

Description

Additional comments or suggestions to improve this manual:

I am using Version ___ of the software this manual describes.

Name/Title

Dept.

Company

Date

Mailing Address
Phone

Do Not Tear - Fold Here and Tape

-------------------~lllr-------~~~~~~--in the
United States

BUSINESS REPLY MAIL
FIRST CLASS PERMIT NO. 33 MAYNARD MASS.
POST AGE WILL BE PAID BY ADDRESSEE

DIGITAL EQUIPMENT CORPORATION
Corporate User Publications-Spit Brook
ZK01-3/J35
110 SPIT BROOK ROAD
NASHUA, NH 03062-9987

11111111111 111111111111111111111111111111 11111111111
- - Do Not Tear - Fold Here - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - .