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

MXCI Commands

HP NonStop SQL/MX Reference Manual—540440-003

4-40

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.

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

commands in the file.

is the input file to MXCI, which might contain any SQL commands, DDL or DML

statements.

MXCI reads each command or statement from the given input file and sends for

execution.

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.2

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 input.sql >>result

MXCI [-ifilename]