SQL Programming Manual for TAL

HP NonStop SQL Programming Manual for TAL—527887-001
A-1
A
Sample NonStop SQL Database
This appendix describes the sample NonStop SQL database used by some of the
examples in this manual. There is one node, the \SYS1 system. The $VOL1 volume on
this system contains the PERSNL, SALES, and INVENT subvolumes. Each subvolume
contains a catalog and tables relating to a specific operation in the organization:
The PARTLOC table is partitioned over three volumes. The other two volumes are
$WHS2 and $WHS3 (indicating the data relates to the parts stored at two different
warehouses).
Figure A-1
on page A-2 shows the names of columns and tables and the relations
between the tables in the sample database.
Figure A-2
on page A-3 shows the source file containing the record descriptions of
database tables. This source file was generated using INVOKE directives executed
from SQLCI. For example, the INVOKE directive used to generate the DEPT table is:
INVOKE persnl.dept FORMAT TAL TO srcfile (dept);
PERSNL Contains the EMPLOYEE, JOB, and DEPT tables, which hold personnel
data.
SALES Contains the CUSTOMER, ORDERS, ODETAIL, and PARTS tables, which
are used for order data.
INVENT Contains the SUPPLIER, PARTSUPP, PARTLOC, and ERRORS tables,
which hold inventory data.