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

Welcome to MXCI and the Sample Database

NonStop HP SQL/MX Quick Start—540438-001

1-2

Entering a Command

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

2.1

You have started an MXCI session.

Entering a Command

To enter commands at the MXCI prompt (>>), you must indicate the end of an MXCI

command by typing a semicolon (;). If you press Enter without typing a semicolon,

MXCI displays the command continuation prompt (+>). You can either continue the

command or type a semicolon and press Enter to execute the command:

>>BEGIN WORK

+>;

--- SQL operation complete.

Stopping MXCI

To end your MXCI session, type this command and press Enter:

>>exit;

End of MXCI Session

You are now back in the OSS environment.

The Sample Database

You will be accessing tables in the sample database for NonStop SQL/MX as you work

through the examples in this tutorial. A table consists of rows and columns. MXCI

displays rows horizontally and columns vertically. Columns have names, rows do not.

Stored data is retrieved and displayed in rows and columns.

•

Each row contains pieces of related data, such as the number of a part, its

description, price, and the quantity available.

•

Each column contains data of the same type, such as all part numbers.

Use the sample database to follow each lesson and perform the operations shown in

the examples. The results of your work should be similar to the results shown in the

examples.