SQL/MX Quick Start (H06.04+, J06.03+)

Welcome to MXCI and the Sample Database

HP NonStop SQL/MX Quick Start—540438-001

1-3

PARTS Table

The SQL/MX Release 2.x sample database uses SQL/MX tables. To create a sample

database using SQL/MP tables, see one of these topics:

•

Using a SQL/MX Release 1.8 setmxdb Script in a SQL/MX Release 2.x

Environment on page 1-9

•

Installing the SQL/MP Sample Database on page 1-10

The sample database consists of a catalog and three schemas:

The Quick Start examples use these tables in the sample database:

•

PARTS Table on page 1-3

•

ORDERS Table on page 1-4

•

ODETAIL Table on page 1-4

•

EMPLOYEE Table on page 1-4

•

DEPT Table on page 1-5

PARTS Table

Part/Num Part Description Price Qty/Avail

-------- ------------------ --------- -----------

212 PC SILVER, 20 MB 2500.00 3525

244 PC GOLD, 30 MB 3000.00 4426

255 PC DIAMOND, 60 MB 4000.00 3321

2001 GRAPHIC PRINTER, M1 1100.00 2100

6500 DISK CONTROLLER 95.00 2532

6603 PRINTER CONTROLLER 45.00 430

7102 SMART MODEM, 1200 275.00 2200

7301 SMART MODEM, 2400 425.00 2332

... ... ... ...

Note. Release 2.x refers to all Release 2.0-based product versions, including Release 2.0,

Release 2.1, Release 2.2, and so on.

SAMDBCA

Sample database catalog.

PERSNL Contains the EMPLOYEE, JOB, DEPT, and PROJECT tables, which

are used to store personnel data.

SALES Contains the CUSTOMER, ORDERS, ODETAIL and PARTS tables,

which are used to store order data.

INVENT Contains the SUPPLIER, PARTSUPP, and PARTLOC tables, which

are used to store inventory data.