SQL/MX Quick Start (G06.24+, H06.03+)

Welcome to Quick Start

HP NonStop SQL/MX Quick Start—523724-002

1-4

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

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

DEPT Table

Dept/Num Dept/Name Mgr Rpt/Dept Location

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

1000 FINANCE 23 9000 CHICAGO

1500 PERSONNEL 213 1000 CHICAGO

2000 INVENTORY 32 9000 LOS ANGELES

2500 SHIPPING 234 2000 PHOENIX

3000 MARKETING 29 9000 NEW YORK

3100 CANADA SALES 43 3000 TORONTO

3200 GERMNY SALES 39 3000 FRANKFURT

3300 ENGLND SALES 72 3000 LONDON

3500 ASIA SALES 111 3000 HONG KONG

4000 RESEARCH 65 9000 NEW YORK

4100 PLANNING 87 4000 NEW YORK

9000 CORPORATE 1 9000 CHICAGO

For more information about the tables in the sample database, see the SQL/MX

Reference Manual.

Installing the setmxdb Script

The OSS installation script, setmxdb, creates and populates the sample database and

is provided as a pax file, T0517PAX, in the temporary OSS installation subvolume

$SYSTEM.ZOSSUTL. The pax file is a multifile archive file that is created by the pax

utility on UNIX-compatible systems. For OSS, pax files provide the form by which

product files are distributed for installation.

Note. To install the SQL/MX Release 2.0 setmxdb script, you must have a license for the use

of SQL/MX DDL statements. To acquire the license, you must purchase product T0394. If you

did not purchase T0394 and you try to install setmxdb, an error message informs you that the

system is not licensed. If the system is not licensed, see “Using a SQL/MX Release 1.8

setmxdb Script in the SQL/MX Release 2.0 Environment” on page 1-10.