Data Definition Language (DDL) Reference Manual (G06.24+)

Sample Schemas
Data Definition Language (DDL) Reference Manual—426798-002
B-7
Sample SPI Schema
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
!***************************************************************
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.
Note that you do not generate COBOL, pTAL, TAL, or TACL source code for the
standard SPI definitions; HP supplies the COBOL, pTAL, TAL, or TACL source code in
these files:
ZSPIDEF.ZSPICOB
ZSPIDEF.ZSPITAL
ZSPIDEF.ZSPITACL
COBOL source code
TAL source code
TACL source code
VSTB01.vsd