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

Welcome to Quick Start
HP NonStop SQL/MX Quick Start—523724-002
1-9
Using a SQL/MX Release 1.8 setmxdb Script in the
SQL/MX Release 2.0 Environment
°
Use the -catalog option when running the SQL/MX Release 2.0 setmxdb.
•
Before running the SQL/MX Release 1.8 setmxdb in a SQL/MX Release 2.0
environment, you must create the catalog and schemas required by the script.
(The default schemas are PERSNL, SALES, and INVENT.) Otherwise, the script
will generate an error. Creating the catalog and schemas in advance is NOT
required when running the SQL/MX Release 2.0 setmxdb.
Alternately, you can run the SQL/MX Release 1.8 setmxdb and use the -noansi
option. This method does not require you to create the catalog and schemas in
advance, but it uses Guardian names for the tables. No SQL/MP aliases are
created.
•
You can run the SQL/MX Release 1.8 setmxdb script from any directory. For more
information about running the SQL/MX Release 1.8 setmxdb script, see the
SQL/MX Quick Start provided for any of these RVUs: G06.18, G06.19, G06.20,
G06.21, or G06.22.