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

HP NonStop SQL/MX Quick Start—523724-002

1-1

1 Welcome to Quick Start

This section provides information about 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 Kernel 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.

4. Start MXCI by entering the mxci command at the OSS prompt:

>mxci

/G/SYSTEM/SYSTEM: mxci

Hewlett-Packard NonStop(TM) SQL/MX Conversational Interface

LP.

You have started an MXCI session.