SQL/MX Report Writer Guide

Using MXCI and the Report Writer

HP NonStop SQL/MX Report Writer Guide—527194-002

2-2

Starting and Ending an MXCI Session

To start an MXCI session, at the OSS shell prompt, enter:

/home/sql:mxci

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

When waiting for a command, MXCI displays the standard MXCI prompt (>>). If you

have not completed a command by entering a semicolon (;), MXCI displays the

command continuation prompt (+>) until a semicolon is entered.

To end an MXCI session, at the MXCI prompt, enter:

>> exit;

End of MXCI Session

The Select-in-Progress Prompt

After you enter the SELECT command in REPORT mode, MXCI displays the select-in-

progress prompt (S>), indicating that MXCI is waiting for report writer commands.

Setting Up Your Session Environment

Any report you create is affected by the current environment of your MXCI session,

such as the current default catalog and schema.

For example, to set a logical name for the default catalog:

SET CATALOG SAMDBCAT;

To set a logical name for the default schema, use the command:

SET SCHEMA SAMDBCAT.SALES;

If an object is on the default schema, you can refer to it by the table name only.

>>SELECT * FROM CUSTOMER;

If you are creating a report that uses data from tables in different schemas, you must

refer to the table by a fully qualified name, including the catalog, schema, and table

name:

>>SELECT * FROM SAMDBCAT.SALES.CUSTOMER;

If you have a default schema set, you can refer to data from tables in that schema by

table name only. However, you must use the fully qualified name for data from tables in

other schemas. You might find it easier in this case not to set a default schema.