Data Definition Language (DDL) Reference Manual

Sample Schemas
Data Definition Language (DDL) Reference Manual—529431-004
B-6
Sample SPI Schema
Sample SPI Schema
The sample SPI schema contains the DDL commands to build a dictionary containing
the token definitions and other information needed by a subsystem that sends and
receives SPI messages. If you do not plan to use SPI messages to communicate
among processes in a Distributed Systems Management (DSM) environment, you
need not refer to this schema.
The sample SPI schema uses standard SPI definitions wherever applicable and
nonstandard definitions only where needed by the subsystem. The standard SPI
definitions are in the file ZSPIDEF.ZSPIDDL on the disk volume selected for your
system. The first step in creating the dictionary is to compile this entire file into your
dictionary using the DDL SOURCE command.
* Contains information about each supplier of parts
RECORD supplier.
FILE IS "$data.sales.supplier" KEY-SEQUENCED
AUDIT
MAXEXTENTS 100.
DEFINITION IS suppinfo.
KEY IS supplier.suppnum DUPLICATES NOT ALLOWED.
KEY "su" IS supplier.suppname.
END
* Contains information about company's regional offices
RECORD region.
FILE IS "$data.sales.region" KEY-SEQUENCED
AUDIT
MAXEXTENTS 100.
DEFINITION IS reginfo.
KEY IS region.regnum DUPLICATES NOT ALLOWED.
KEY "rn" IS region.regname.
END
* Contains information about company's branch offices
RECORD branch.
FILE IS "$data.sales.branch" KEY-SEQUENCED
AUDIT
MAXEXTENTS 100.
DEFINITION IS branchinfo.
KEY IS branch.primkey DUPLICATES NOT ALLOWED.
END
* Contains information about each employee
RECORD employee.
FILE IS "$data.sales.employee" KEY-SEQUENCED
AUDIT
MAXEXTENTS 100.
DEFINITION IS empinfo.
KEY IS employee.empnum DUPLICATES NOT ALLOWED.
KEY "en" IS employee.empname.
KEY "dp" IS employee.dept.
END
!***************************************************************
! END OF SCHEMA1 DATABASE DESCRIPTION
!***************************************************************
Figure B-1. Database Schema Listing (page5of5)