Introduction to Pathmaker

Tandem Databases and TMF
Introduction to Pathmaker and Pathway
1–38 067867 Tandem Computers Incorporated
Table 1-1 compares some of the features and uses of the NonStop SQL and Enscribe
products.
Table 1-1. Comparison of NonStop SQL and Enscribe Products (Page 1 of 2)
NonStop SQL Enscribe
How data is stored Tables on disk.*
(A special set of tables, called an
SQL catalog, holds information
describing these tables.)
Database must exist before the
Pathmaker product is used,
although tables can be empty.
Files on disk (entry-sequenced,
relative, key-sequenced). Database
does not have to exist until
Pathmaker application is tested.
How database is
created
Database administrator:
1. Creates TEDIT file (schema) of
DDL statements describing the
database and other structures.
2. Compiles schema with DDL
program (through Pathmaker
interface) requesting DDL dictionary
updates.
3. Uses NonStop SQL
Conversational Interface (SQLCI)
CONVERT utility to create TEDIT
file that contains SQL commands
created from information in DDL
dictionary.
4. Obeys the file created in Step 3
through SQLCI interface to create
tables, indexes, and so forth.
5. Loads data.
OR
1. Creates TEDIT file of SQL
statements for creating tables,
views, indexes, and so forth.
2. Uses TEDIT file as input to
NonStop SQL Conversational
Interface (SQLCI) to create tables,
indexes, and so forth.
3. Loads data.
Database administrator:
1. Creates TEDIT file (schema) of
DDL statements describing the
database and other structures.
2. Compiles schema with DDL
program (through Pathmaker
interface) asking for FUP output.
3. DDL program generates FUP
commands.
4. Executes FUP commands to
create files.
5. Loads data.
* SQL tables are perceived by the end user to be two-dimensional tables, although they are actually
stored in key-sequenced, entry-sequenced, or relative files.