SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Introduction

HP NonStop SQL/MX Reference Manual—544517-008

1-2

MXCI SQL/MX Conversational Interface

SQL/MX language elements are part of statements and commands and include data

types, expressions, functions, identifiers, literals, and predicates. For more information,

see Section 6, SQL/MX Language Elements. For more information on specific

functions and expressions, see Section 9, SQL/MX Functions and Expressions.

User metadata tables, such as the SYSTEM_DEFAULTS table, histogram tables, and

other tables, contain SQL/MX metadata that the user rather than the system maintains.

For more information, see Section 10, Metadata Tables.

MXCI SQL/MX Conversational Interface

MXCI, the SQL/MX conversational interface, is useful for running ad hoc queries and

for comparing the relative efficiency of various queries.

MXCI Session

You start MXCI by using the MXCI command within the OSS environment. For

example, the commands you enter and the MXCI banner might look like this:

$DATA06 TEMP 19> osh

/G/SYSTEM/SYSTEM: mxci

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

During a session, MXCI prompts you to enter SQL/MX statements or MXCI commands

with one of these prompts:

You end an MXCI session with the EXIT command. See EXIT Command on

page 4-28.

The MXCI returns completion status for the session after executing the entered

SQL/MX commands or SQL/MX statements:

0 - All statements executed without any errors or warnings.

1 - One or more statements in the MXCI session returned warnings.

2 - One or more statements in the MXCI session returned errors.

>> The standard prompt. Enter any MXCI command, Report Writer command,

or SQL/MX statement.

+> The continuation prompt. Continue the MXCI command or SQL/MX

statement from the previous line or enter a semicolon to end it.

.. The FC command prompt. See FC Command on page 4-29.

S> The Report Writer select-in-progress prompt, available only in Report

Writer mode. For more information, see the Report Writer Guide.

CS> The MX Connectivity Services prompt, available only in MXCS mode.