SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

MXCI Commands

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004

4-55

MXCI Command

MXCI is the command that starts an MXCI session from the OSS environment.

filename

specifies the file from which MXCI reads the commands.

The file must either be closed or open for read only.

The file must be an OSS text file (an odd-unstructured file, type 180) or a file

specified with a Guardian path name which is an EDIT file (type 101).

If the -i option is specified, MXCI stops the session immediately after executing the

commands in the file.

If the -s or -script option is specified, MXCI session waits for user inputs after

executing the commands in the file.

-i, -s, and -script options are mutually exclusive.

Examples of MXCI Command

•

Start the console version of MXCI by using the MXCI command:

/mxutil/sys 1>mxci

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

You can stop an MXCI session by using the EXIT command. See EXIT Command

on page 4-28.

•

For command:

mxci -i input.sql

The contents of input.sql could be:

drop table tab;

create table tab(a INT);

insert into tab values(10);

select * from tab;

The results of input file can be stored in another file using:

mxci -i inputfile >>outputfile

For example:

mxci [-i filename] | [{ -s | -script } filename]