Data Definition Language (DDL) Reference Manual

Sample Schemas
Data Definition Language (DDL) Reference Manual—529431-004
B-5
Database Schema Listing
!***************************************************************
! FILE DEFINITIONS
!***************************************************************
* Contains customer information for each customer
RECORD customer.
FILE IS "$data.sales.customer" KEY-SEQUENCED
AUDIT
MAXEXTENTS 100.
DEFINITION IS custinfo.
KEY IS customer.custnum DUPLICATES NOT ALLOWED.
KEY "cn" IS customer.custname.
END
* Contains order information for each order
RECORD orders.
FILE IS "$data.sales.orders" KEY-SEQUENCED
AUDIT
MAXEXTENTS 100.
DEFINITION IS orderinfo.
KEY IS orders.ordernum DUPLICATES NOT ALLOWED.
KEY "sn" IS orders.salesperson.
KEY "cn" IS orders.custnum.
END
* Contains each order line for each order
RECORD odetail.
FILE IS "$data.sales.odetail" KEY-SEQUENCED
AUDIT
MAXEXTENTS 100.
02 primkey.
03 ordernum TYPE *.
03 partnum TYPE *.
02 quantity PIC 9(3).
KEY IS primkey DUPLICATES NOT ALLOWED.
END
* Contains information on each part
RECORD parts.
FILE IS "$data.sales.parts" KEY-SEQUENCED
AUDIT
MAXEXTENTS 100.
DEFINITION IS partsinfo.
KEY IS parts.partnum DUPLICATES NOT ALLOWED.
KEY "pn" IS parts.partname.
END
* Contains a record of each part ordered from each supplier
RECORD fromsup.
FILE IS "$data.sales.fromsup" KEY-SEQUENCED
AUDIT
MAXEXTENTS 100.
02 primkey.
03 partnum TYPE *.
03 suppnum TYPE *.
02 partcost PIC 9(6)V9(2)
DISPLAY part-cost-display.
KEY IS primkey DUPLICATES NOT ALLOWED.
END
Figure B-1. Database Schema Listing (page4of5)