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
Содержание DDL D40
Страница 36: ...Introduction to DDL Data Definition Language DDL Reference Manual 426798 002 1 14 Examining a Dictionary ...
Страница 66: ...Named Constants Data Definition Language DDL Reference Manual 426798 002 4 10 Standard SPI Constants ...
Страница 230: ...Dictionary Manipulation Statements Data Definition Language DDL Reference Manual 426798 002 8 14 SHOW USE OF Statement ...
Страница 370: ...Dictionary Maintenance Data Definition Language DDL Reference Manual 426798 002 10 24 Converting a Dictionary ...
Страница 456: ...Sample Schemas Data Definition Language DDL Reference Manual 426798 002 B 12 ASSNDDL Statements ...
Страница 470: ...DDL Data Translation Data Definition Language DDL Reference Manual 426798 002 C 14 ...
Страница 528: ...Dictionary Reports Data Definition Language DDL Reference Manual 426798 002 E 8 Requesting Reports ...
Страница 552: ...DDL Alignment Rules Data Definition Language DDL Reference Manual 426798 002 H 4 FIELDALIGN_SHARED8 Alignment Rules ...
Страница 576: ...Index Data Definition Language DDL Reference Manual 426798 002 Index 22 Special Characters ...