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-56
Examples of MXCI Command
mxci -i input.sql >>result
•
Example of MXCI command-line option -s
mxci -s inputfile.sql
The contents of the inputfile.sql can be:
Create catalog tempcat;
Create schema tempcat.tempsch;
Set schema tempcat.tempsch;
Create table sampletab(a int);
Insert into sampletab values(10);
Select * from sampletab;
The result after running the command:
Hewlett-Packard NonStop(TM) SQL/MX Conversational
Interface 3.2.1
(c) Copyright 2003, 2004-2013 Hewlett-Packard Development
Company, LP.
>>Create catalog tempcat;
--- SQL operation complete.
>>Create schema tempcat.tempsch;
--- SQL operation complete.
>>Set schema tempcat.tempsch;
--- SQL operation complete.
>>Create table sampletab(a int);
--- SQL operation complete.
>>Insert into sampletab values(10);
--- 1 row(s) inserted.
>>Select * from sampletab;
A
-----------
10
--- 1 row(s) selected.
>>