SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

S-1

Sample Database

To help users of NonStop SQL/MP become familiar with the product's features, HP

includes a sample database and a sample application on the product site update tape

(SUT). The sample database demonstrates the use of NonStop SQL/MP in a Pathway

transaction processing environment. It includes several host language programs that

use embedded SQL statements to access the sample database. Users can also

access the sample database with SQLCI commands.

The source code, database creation and load files, and installation instructions for the

sample database and application are stored on a file named DOCUMENT on a

subvolume named ZTSQLMSG when NonStop SQL/MP is installed. (The volume

name is specified at installation time by the user who installs NonStop SQL/MP. To

determine the volume name, check with the group that installs NonStop SQL/MP at

your site.) If you set your volume default to the appropriate disk volume, you can use

this command to print the installation instructions:

35> TGAL /IN ZTSQLMSG.DOCUMENT, OUT $S.#printer/

The sample database is used as the basis for many examples in the NonStop SQL/MP

manuals. In the examples, most of the sample database is presented as installed on

three subvolumes—PERSNL, SALES, and INVENT—on a single volume. Each

subvolume contains a catalog and tables relating to a specific operation in the

organization:

One table in the sample data base—the PARTLOC table—can be installed as a

partitioned table. The examples show it as partitioned over three volumes on two

different nodes.

For more information about the sample database or the sample application, see the

DOCUMENT file. For the host language you use for the illustration "Sample NonStop

SQL Database Relations" which shows the relationships between the tables in the

sample database, for more information, see the SQL/MP programming manual.

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. Also contains the SUPPKANJ table,

which accepts Kanji data for the supplier's name and address.

INVENT Contains the SUPPLIER, PARTSUPP, PARTLOC, and ERRORS

tables, which hold inventory data.