SQL/MX 2.x Reference Manual (H06.04+)

Introduction
HP NonStop SQL/MX Reference Manual—540440-003
1-2
MXCI SQL/MX Conversational Interface
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.2
(c) Copyright 2006 Hewlett-Packard Development Company, LP.
>>
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 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.