Pathmaker Programming Guide

Defining Data for a Pathmaker Project
Preparing for Pathmaker Application Development
067868 Tandem Computers Incorporated 2–31
Creating the Physical
Database
For Pathmaker applications that access Enscribe files, those Enscribe files do not have
to exist until the application is ready for testing. For Pathmaker applications that
access NonStop SQL tables and views, those tables and views must exist before the
Pathmaker product can be used to create the application.
Enscribe
If you choose to wait until testing time to create the files, you will be able to use a FUP
command file that the Pathmaker utility called PMPROJECT INSTALL creates as part
of application installation. If you want to create the Enscribe files before that time, you
can execute DDL commands, using the schema you created as input, to create a file of
FUP commands. The FUP commands file, whether created using PMPROJECT
INSTALL or created directly from your schema, is then input into FUP, which creates
the physical Enscribe files you described. See the Data Definition Language (DDL)
Reference Manual for an example of how to create an Enscribe database using a schema.
NonStop SQL
NonStop SQL, including the NonStop SQL Conversational Interface (SQLCI), is used
to create a NonStop SQL database and associated SQL Catalogs. The NonStop SQL
Conversational Interface can be accessed either through the Pathmaker full screen
interface or outside of the Pathmaker environment. Use the file you created to
describe the database as input. Refer to the NonStop SQL Conversational Interface
Reference Manual for information about creating a NonStop SQL database.
Describing Data to
Pathmaker
Prior to describing data to a Pathmaker project, you must add a Pathmaker project for
your application. When you add a project, the Pathmaker product creates a DDL
dictionary as part of the project catalog.
Updating the DDL Dictionary for a Pathmaker Project
If you created a DDL schema (whether for Enscribe files or NonStop SQL tables), you
must enter the DDL interface through the Pathmaker full screen interface and then
update the DDL dictionary in the Pathmaker project catalog by compiling the schema.
For example:
?OUT $S.#PRT
?SOURCE PMDDL.MYDDL
When DDL is accessed from the Pathmaker full screen interface, the dictionary is
opened for update access. The DDL dictionary can be opened for update access by
more than one user at the same time. Refer to the Data Definition Language (DDL)
Reference Manual for additional information about updating a DDL dictionary.