SQL/MP Programming Manual for C

HP NonStop SQL/MP Programming Manual for C—429847-008
A-1
A SQL/MP Sample Database
This appendix describes the NonStop SQL/MP sample database included on the
product site update tape (SUT). Many examples in this manual (in addition to other
SQL/MP manuals) refer to this sample database. You can create your own copy of the
sample database and access it using SQLCI commands or by embedding SQL
statement in a host-language program.
The sample database includes the PERSNL, SALES, and INVENT subvolumes. Each
subvolume contains a catalog and these tables:
HP distributes the sample database in the ZTSQLMSG subvolume. (Ask your
database administrator or system manager for the volume where the ZTSQLMSG
subvolume is installed on your system.)
The ZTSQLMSG.DOCUMENT file describes the files in the ZTSQLMSG subvolume.
The DOCUMENT file also explains how to create a copy of the sample database. To
print the DOCUMENT file, enter this TGAL command at your TACL prompt:
TGAL / IN ZTSQLMSG.DOCUMENT, OUT $S.#loc /
The loc parameter is a spooler location for your system.
PERSNL EMPLOYEE, JOB, and DEPT tables, which hold personnel data.
SALES CUSTOMER, ORDERS, ODETAIL, and PARTS tables, which are used
for order data. Also, the SUPPKANJ table, which accepts Kanji data for
the supplier’s name and address.
INVENT SUPPLIER, PARTSUPP, PARTLOC, and ERRORS tables, which hold
inventory data. (PARTLOC can be partitioned over three volumes, if they
are available.)