Digital PDFs

AE-H113D-TE

May 1980

2 pages

Original

0.1MB

Document:	25.14.03 8005 PDP-11 DATATRIEVE VAX 2.0
Order Number:	AE-H113D-TE
Revision:
Pages:	2
Original Filename:	http://bitsavers.org/pdf/dec/spd/25.14.03_8005_PDP-11_DATATRIEVE_VAX_2.0.pdf

OCR Text

~D~DDmD

Software Product Description
PRODUCT NAME: PDP-11 DATATRIEVE/VAX, Version 2.0

DESCRIPTION:
PDP-11 DATATRIEVE/VAX is an interactive query,
report generation, and data maintenance system that
runs under VAX/VMS in compatibility mode. It is selfteaching and requires little previous computer experience for the user to take full advantage of its capabilities.
DATATRI EVE accesses data contained in files of
sequential, indexed, or relative organization. DATATRI EVE provides facilities for selective data retrieval,
sorting, formatting, updating, and report generation
without the need for programming overhead.
Record and domain (file) definitions entered in DATATRIEVE are stored in Data Dictionaries shared by
DATATRIEVE users. These Dictionaries can also be
used to store frequently used sequences of commands
to be recalled and processed later. Additional commands are provided to list the contents of the Data
Dictionary, to delete entries, and to control access to
individual entries in the Data Dictionary. A dictionary
compression utility is also available to clean up the
Data Dictionary index file.
DATATRIEVE enables the user to define domains that
cross RMS file definitions and subset record
defi n itions.
DATATRIEVE provides an Application Design Tool
(ADT) to assist the novice user in creating domain and
record definitions. The ADT uses an interactive dialogue technique to guide the user through the data
definition process. It creates an indirect command file
which is then processed to actually update the DATATRIEVE Data Dictionary.
The DATA TR I EVE report writer provides easy-to-use
commands to control the following report functions:
Report name, date, and page numbering
Page width and length speCification
Detail line specification
Multiple control break specification with automatic
totaling at any level
• Multiple report sections

SPO 25.14.3

• HELP provides a summary of each DATATRIEVE
command.
• READY identifies a domain for processing and controls the access mode to the appropriate file.
• FIND establishes a collection (subset) of records
contained in either a domain or a previously established collection based on a Boolean expression.
• SORT reorders a collection of records in either the
ascending or descending sequence of the contents
of one or more fields in the records.
• PRINT prints one or more fields of one or more
records. Output can optionally be directed to a line
printer or disk file. Format control can be specified.
A column header is generated automatically.
• SELECT identifies a single record in a collection for
subsequent individual processing.
• MODIFY alters the values of one or more fields for
either the selected record or all records in a collection. Replacement values are prompted for by name.
• STORE creates a new record. The value for each
field contained in the record is prompted for by
name.
• ERASE removes one or more records corresponding to the appropriate domain.
• FOR executes a subsequent command once for
each record in record collection, providing a simple
looping facility.
• EDIT invokes an editor which inserts, replaces, or
deletes text from procedures defined in the Data
Dictionary.
• DECLARE defines global and local variables to be
used within a DATATRIEVE query.

•
•
•
•

• DEFINE provides a consistent mechanism for creating domain, record, procedure, table and view definitions in the Data Dictionary.

DATATRIEVE report commands can be freely intermixed with other DATATRIEVE commands.

In addition to the simple data manipulation commands,
a number of more complex commands are available for
the advanced user. These commands, such as REPEAT, BEGIN-END, and IF-THEN-ELSE, can be used
to combine two or more DATATRI EVE commands into
a single compound command. These, in turn, may be
stored in the Data Dictionary as procedures for invocation by less experienced users.

DATATRIEVE uses a set of English language-like
commands for data retrieval, modification, and display. Prompting is automatic for both command and
data entry. The major commands are as follows:
May 1980

AE-H 1130-TE

SPD 25.14.3

PDP-11 DATATRIEVE/VAX, Version 2.0

-2-

DATATRIEVE provides a full set of arithmetic operators (addition, subtraction, multiplication, division,
and negation), a set of statistical operators (total, average, maximum, minimum, and count), and provides
automatic conversion between data types used in the
FORTRAN, COBOL, DIBOL, and BASIC-PLUS-2
languages.
An additional data type is provided that recognizes
various date formats.
DATATRIEVE provides data encoding, decoding and
input validation capabilities through tables stored in
the Data Dictionary. The user can also check data
validity by storing validation criteria in the record
definition.
MINIMUM HARDWARE REQUIRED:
Any valid VAX/VMS Operating System configuration
OPTIONAL HARDWARE:
None

which provide in part that the software and any part
thereof may be used on only the single CPU on which
the software is first installed, and may be copied, in
whole or in part (with the proper inclusion of the
DIGITAL copyright notice and any DIGITAL proprietary notices on the software) only for use on such CPU.
All source licensed software is furnished only under
the terms and conditions of a separate Software Program Sources License Agreement between Purchaser
and DIGITAL.
Options with no support services are only available
after the purchase of one supported license.
A single-use license only option is a license to copy the
software previously obtained under license.
The following key (Y, Z) represents the distribution
media forthe product and must be specified at the end
of the order number e.g., QE1 05-A Y =binaries on RX01
Floppy Diskette.

= RX01 Floppy Diskette
= No hardware dependency

PREREQUISITE SOFTWARE:

Y
Z

VAX/VMS, Version 2.0

QE105

-A- Single-use license, binaries, documentation, support services (media: Y)

QE105

-0- Single-use license only, no binaries, no

OPTIONAL SOFTWARE:
None

documentation, no support services
(media: Z)

TRAINING CREDITS:
None

Update Options

SUPPORT CATEGORY:
DIGITAL SUPPORTED
PDP-11 DATATRIEVE/VAX is a DIGITAL Supported
Software Product.

Users of PDP-11 DATATRIEVE/VAX whose specified
Support Category warranty has expired may order
under license the following software update at the then
current charge for such update. The update is distributed in binary form on the appropriate medium and
includes no installation or other services unless specifically stated.
.

SOFTWARE INSTALLATION:
CUSTOMER INSTALLED
PDP-11 DATATRIEVE/VAX is a software product engineered to be installed by the customer and includes
other Software Product Support services listed below.

QE105

-H- Binaries, documentation (media: Y)

QE105

-H- Right to copy for single-use (under existting license), no binaries, no documentation (media: Z)

SOFTWARE PRODUCT SUPPORT:
PDP-11 DATATRIEVE/VAX includes standard warranty services as defined in the Software Support
Categories Addendum of this SPD.
ORDERING INFORMATION:
All binary licensed software, including any subsequent
updates, is furnished under the licensing provisions of
DIGITAL's Standard Terms and Conditions of Sale,

Miscellaneous Options

QE105

-G- Documentation only kit (media: Z)

ADDITIONAL SERVICES:
Post-warranty Software Product Services for this software product are available with the prerequisite being
the purchase of the VAX/VMS Self-Maintenance Service for Software. Customers should contact their local
DIGITAL office for additional information.