Pathmaker Programming Guide

Defining Data for a Pathmaker Project
Preparing for Pathmaker Application Development
067868 Tandem Computers Incorporated 2–27
Documenting NonStop SQL
Data
The file used to create the physical database contains NonStop SQL data definition
statements to create all of the tables, views, constraints, and indexes needed by this
application (unless, of course, these structures already exist). This file will be used as
input into the NonStop SQL Conversational Interface (SQLCI). The following is an
example of such a file:
?SECTION VEHICLE
CREATE TABLE =VEHICLE (
LICENSE_PLATE PIC X(06) NOT NULL,
VEHICLE_TYPE PIC 9(02) NOT NULL,
YEAR PIC 9(04) NOT NULL,
MAKE PIC X(12) NOT NULL,
MODEL PIC X(12) NOT NULL,
ENGINE_NUMBER PIC X(08) NOT NULL,
REGISTRATION_DATE PIC 9(06) NOT NULL, -- YYMMDD FORMAT
SALES_PRICE PIC 9(09) NOT NULL, -- (DOLLAR AMT
ONLY)
PERSON_ID PIC S9(10) NOT NULL,
PRIMARY KEY LICENSE_PLATE
)
CATALOG PMSQLCAT
ORGANIZATION KEY SEQUENCED
AUDIT
;
CREATE INDEX =VEHICLE0
ON =VEHICLE (ENGINE_NUMBER)
CATALOG PMSQLCAT
;
CREATE INDEX =VEHICLE1
ON =VEHICLE (PERSON_ID)
CATALOG PMSQLCAT
;
.
.
.