Pathmaker Programming Guide

Creating a NonStop SQL Pathmaker Application
Sample Pathmaker Sessions
067868 Tandem Computers Incorporated 10–35
The menu screen, SQL-MAIN-MENU, is a MENU requester that provides access to the
parts information screen and the order information screen.
The parts information screen, SQL-ENTER-PARTS, is a DB requester that uses
standard services to enter parts rows into the parts information table. You can also use
this screen to update or delete parts rows.
The order information screen, SQL-ORDER-TAKER, is a TRNS requester that uses one
custom service, SQL-PLACE-ORDER. Given the part number and quantity needed,
SQL-PLACE-ORDER enters the order information into the ORDERS table and updates
the quantity available in the PARTS table.
The orders list screen, SQL-ORDERS-LIST, is a TRNS requester that uses two custom
services: SQL-LIST-FIRST and SQL-LIST-NEXT. SQL-LIST-FIRST lists the first ten
orders in the ORDERS table by order number. SQL-LIST-NEXT lists the next ten
orders in the ORDERS table.
To create this application, the following aids are provided:
A list of the steps that you need to take to create your application. These steps are
shown on the following pages.
A screen-by-screen example describing where you enter information on each
screen to create this application. (To make the most effective use of the sample
sessions, you should enter information through the Pathmaker full screen interface
as you follow the steps.)
An SQL-DDL source code file (SQLDDL), an Enscribe DDL source code file
(IPCDDL), and a custom source file (SERVCOD3) containing SQL-COBOL code
for the two custom services. These files are installed on the Pathmaker release
subvolume.
Note If a Custom Source File for these services has not been provided for you, you can use the SQL
Operations screen and the Operations Attributes screen to specify information that allows the Pathmaker
product to generate SQL statements for use in the custom source file.
Before beginning the Pathmaker session, you must:
Copy the source files from the Pathmaker release subvolume.
Add a new Pathmaker project.
Alter the system default NonStop SQL catalog to your working catalog.
To copy the source files from the Pathmaker release subvolume, enter the following
commands at the TACL prompt (replace XX with your initials):
20> VOLUME XX s3pm
21> FUP DUP $ release-vol . release-subvol .SQLDDL, *
22> FUP DUP $ release-vol . release-subvol .IPCDDL, *
23> FUP DUP $ release-vol . release-subvol .SERVCOD3, *
XXs3pm is the work subvolume for this sample session.