SQL/MP Programming Manual for COBOL

HP NonStop SQL/MP Programming Manual for COBOL—529758-003
A-1
A SQL/MP Sample Database
This appendix describes the NonStop SQL/MP sample database and sample
application that are included on the product site update tape (SUT). Many examples in
this manual (as well as other SQL/MP manuals) refer to the 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:
The sample application demonstrates the use of SQL/MP in a Pathway environment. It
includes requestors written in SCREEN COBOL and servers written in C, COBOL,
Pascal, and TAL. The servers use embedded SQL statements to access the sample
database.
HP distributes the sample database and application 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 and
how to compile and run the sample application. To print the DOCUMENT file, enter this
command at the TACL prompt:
10> 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.)