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

HP NonStop SQL/MX Quick Start—540438-001
1-1
1 Welcome to MXCI and the
Sample Database
This section describes how to use MXCI and how to install the sample database that is
used in the Quick Start tutorial.
What Is MXCI?
MXCI is the conversational interface to the SQL/MX relational database management
system. Use MXCI to perform data manipulation operations without any programming.
Use SQL (the structured query language) within MXCI to display and modify
information in your database.
Using MXCI
Data Manipulation Language (DML) statements are used to access SQL/MP and
SQL/MX tables. For more information about using DML statements, see the SQL/MX
Reference Manual.
Starting MXCI
MXCI runs as an HP NonStop operating system Open System Services (OSS) process
and must be started from within the OSS environment:
1. Log on to the server by using your user ID and password.
2. To set the default directory, set the TACL HOME parameter to specify the location
for your home directory. Note that the OSS environment is case-sensitive.
For example, to set your home directory to /usr/yourname, insert this line in
your TACLCSTM file:
PARAM HOME /usr/yourname
3. Start the OSS shell by entering the osh command at the TACL prompt:
>osh
You are now in the OSS environment.