Introduction to Pathmaker

Tandem Databases and TMF
Introduction to Pathmaker and Pathway
067867 Tandem Computers Incorporated 1–37
Database Types and
Pathmaker
Basically, all Pathmaker applications are built in the same way, regardless of whether
they will be accessing data in a NonStop SQL database or in Enscribe files.
The area most affected by the choice of database is the creation and compilation of
service and server code. The programming language statements used to read, write,
and modify a NonStop SQL database are different from those used to perform the
same types of functions on an Enscribe database. In addition, for applications that
access a NonStop SQL database, the Pathmaker product can be used to generate SQL
data manipulation statements from information application developers enter on
Pathmaker screens.
Pathmaker and the DDL Dictionary
The Pathmaker product uses information in the DDL dictionary to generate requesters
and servers and perform other tasks. A source schema describing all IPC messages
and certain screen fields should be created, regardless of the database product
(NonStop SQL or Enscribe) an application will be using. This schema should be
compiled to update the DDL dictionary that is contained in the Pathmaker catalog.
For more information regarding Enscribe DDL, consult the Data Definition Language
(DDL) Reference Manual.
NonStop SQL Table Registration
If a Pathmaker application is being created to access NonStop SQL tables (and views of
tables), the Pathmaker product must be able to locate those tables. A data entry
screen, called the SQL Table Registration screen, is used to provide the Pathmaker
product with this location information. All tables used by a Pathmaker application
must exist and be registered in the Pathmaker catalog before the application’s
requesters, services, or servers are created.
Variations in the procedures for using the Pathmaker product caused by the database
product (NonStop SQL or Enscribe) selected will be noted in the applicable sections of
the Pathmaker Programming Guide.