Pathmaker Programming Guide

Creating a NonStop SQL Pathmaker Application
Sample Pathmaker Sessions
10–36 067868 Tandem Computers Incorporated
$ release-vol . release-subvol is the volume and subvolume on which the
Pathmaker object files are installed. (You might want to print out these files so you
can refer to them while you are creating the application.)
To add the project, enter the following command at the TACL prompt (replace XX
with your initials):
24> PMPROJECT ADD XX- SESSION-3
XX-SESSION-3 is your Pathmaker project name. PMPROJECT prompts you for
further information required to add the project.
Before beginning the Pathmaker session, you must decide to either create a new
NonStop SQL catalog or use an existing catalog. (Directions for creating a new catalog
are provided in Step 1.) In either case, alter the system default NonStop SQL catalog
so that Pathmaker automatically retrieves information from that catalog. For example,
if you will be creating a catalog from TACL named XXSQLCAT, where XX is your
initials, enter the following command:
25> SET DEFMODE ON
26> ALTER DEFINE =_DEFAULTS, CATALOG XX sqlcat
If you are using an existing catalog, use the name of that catalog instead.
After you have altered the system default catalog, start the Pathmaker full screen
interface by entering the following command (replace XX with your initials):
27> PATHMAKER XX- SESSION-3
Summary of Application
Creation Steps
The steps you must take to create your application are summarized below:
1. Create NonStop SQL catalog (if necessary).
2. Create tables for the application.
3. Use the Enscribe DDL source file provided to load the DDL dictionary for this
project.
4. Register tables and view default access paths.
5. Define SQL-PLACE-ORDER service.
a. Enter basic service information.
b. Define IPC messages.
c. Specify host variable names.
6. Define SQL-ORDERS-LIST-FIRST service.
a. Enter basic service information.
b. Define IPC messages.
c. Specify the host variable name.
7. Define SQL-ORDERS-LIST-NEXT service.
a. Enter basic service information.