Data Definition Language (DDL) Reference Manual

Sample Schemas
Data Definition Language (DDL) Reference Manual—529431-004
B-4
Database Schema Listing
* Definition for ORDERS Record
DEFINITION orderinfo.
02 ordernum TYPE *.
02 orderdate TYPE mdy-date.
02 deldate TYPE mdy-date.
02 salesperson TYPE empnum
HEADING salesperson-heading.
02 custnum TYPE *.
END
* Definition for PARTS Record
DEFINITION partsinfo.
02 partnum TYPE *.
02 partname TYPE name.
02 inventory PIC 9(3)S.
02 location PIC X(3).
02 price PIC 9(6)V9(2).
END
* Definition for SUPPLIER Record
DEFINITION suppinfo.
02 suppnum TYPE *.
02 suppname TYPE name.
02 addr TYPE *.
END
* Definition for REGION Record
DEFINITION reginfo.
02 regnum TYPE *.
02 regname PIC X(12).
02 location PIC X(14).
02 manager TYPE empnum
HEADING manager-heading.
END
* Definition for BRANCH Record
DEF branchinfo.
02 primkey.
03 regnum TYPE *.
03 branchnum TYPE *.
02 branchname PIC X(14).
02 manager TYPE empnum
HEADING manager-heading.
END
* Definition for EMPLOYEE Record
DEFINITION empinfo.
02 empnum TYPE *.
02 empname TYPE name.
02 dept.
03 regnum TYPE *.
03 branchnum TYPE *.
02 job PIC X(12).
02 age PIC 9(2).
02 salary PIC 9(6).
02 vacation PIC 9(2).
END
Figure B-1. Database Schema Listing (page3of5)