Introduction to Pathmaker

Tandem Databases and TMF
Introduction to Pathmaker and Pathway
067867 Tandem Computers Incorporated 1–39
Table 1-1. Comparison of NonStop SQL and Enscribe Products (Page 2 of 2)
NonStop SQL Enscribe
How database and
other application
structures (IPC
messages and so
forth) are described to
Pathmaker
Application developer:
1. Registers SQL tables with
Pathmaker screen.
2. Creates DDL schema describing
data that is not part of the database
(such as screen-only fields) then
compiles with DDL program
(through Pathmaker interface)
requesting DDL dictionary updates.
Application developer:
1. Compiles schema used to create
the database with DDL program
(through Pathmaker interface)
requesting DDL dictionary updates.
How database is
accessed by a server
Application developers write SQL
data manipulation statements, such
as SELECT and INSERT, in the
services. (Pathmaker can generate
some of these statements.) Data
manipulation statements cause
NonStop SQL to perform
processing on one or more rows
from a table.
Application developers write
program statements in the services
(such as Read and Write) that
cause Enscribe to perform record-
at-a-time access to the database.