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

Welcome to MXCI and the Sample Database
NonStop HP SQL/MX Quick Start—540438-001
1-4
ORDERS Table
ORDERS Table
Order/Num Order/Date Deliv/Date Sales/Rep Cust/Num
--------- ---------- ---------- --------- --------
100210 2003-04-10 2003-04-10 220 1234
100250 2003-01-23 2003-06-15 220 7777
110220 2003-07-21 2003-12-15 221 5635
... ... ... ... ...
ODETAIL Table
Order/Num Part/Num Unit/Price Qty/Ord
--------- -------- ---------- -------
100210 244 3000.00 3
100210 2001 1100.00 3
100210 2403 620.00 6
100210 5100 150.00 10
100250 244 3500.00 4
100250 5103 400.00 10
... ... ... ...
800660 7102 275.00 6
800660 7301 425.00 12
EMPLOYEE Table
Employee/Number First Name Last Name Dept/Num Job/Code Salary
--------------- ---------- --------- -------- -------- ---------
1 ROGER GREEN 9000 100 175500.00
23 JERRY HOWARD 1000 100 137000.10
29 JANE RAYMOND 3000 100 136000.00
32 THOMAS RUDLOFF 2000 100 138000.40
39 KLAUS SAFFERT 3200 100 75000.00
43 PAUL WINTER 3100 100 90000.00
65 RACHEL MCKAY 4000 100 118000.00
72 GLENN THOMAS 3300 100 80000.00
75 TIM WALKER 3000 300 32000.00
87 ERIC BROWN 4100 400 89000.00
89 PETER SMITH 3300 300 37000.40
... ... ... ... ... ...