SQL/MX 2.x Reference Manual (H06.04+)

HP NonStop SQL/MX Reference Manual—540440-003
D-1
D Sample Database
To help you become familiar with its features, NonStop SQL/MX includes a sample
database, which you can access by using SQL/MX statements. The sample database
is used as the basis for many examples in this manual and other SQL/MX manuals.
The DDL statements in the sample database use SQL/MX tables. If you are using
SQL/MP tables, you need to use the SQL/MX Release 1.8 sample database, which
uses SQL/MP tables.
This appendix describes:
•
Object Names in Sample Database
•
Sample Database Entity-Relationship Diagram
•
DDL Statements for the Sample Database
For more information on how to install the sample database, see the SQL/MX Quick
Start.
Object Names in Sample Database
The catalog name for the sample database is samdbcat by default, and the catalog
contains three schemas—PERSNL, SALES, and INVENT.
The DML examples in this manual use three-part logical names,
catalog.schema.name, because ANSI SQL:1999 applications use logical names.
Note. The SQL/MX Release 2.x sample database uses SQL/MX format tables. To install the
sample database, you must have a license to use SQL/MX DDL statements. To acquire this
license, purchase product T0394. Without this product, you cannot install the sample database;
an error message informs you that the system is not licensed.
PERSNL Contains the EMPLOYEE Table, JOB Table, DEPT Table, and
PROJECT Table, which are used to store personnel data.
SALES Contains the CUSTOMER Table, ORDERS Table, ODETAIL Table,
and PARTS Table, which are used to store order data.
INVENT Contains the SUPPLIER Table
, PARTSUPP Table, and PARTLOC
Table, which are used to store inventory data.