SQL/MX Quick Start (G06.24+, H06.03+)

Welcome to Quick Start
HP NonStop SQL/MX Quick Start—523724-002
1-2
Entering a Command
Entering a Command
To enter commands at the MXCI prompt (>>), you must indicate the end of an MXCI
command by typing a semicolon (;). If you press Enter without typing a semicolon,
MXCI displays the command continuation prompt (+>). You can either continue the
command or type a semicolon and press Enter to execute the command:
>>BEGIN WORK
+>;
--- SQL operation complete.
>>
Stopping MXCI
To end your MXCI session, type this command and press Enter:
>>exit;
End of MXCI Session
You are now back in the OSS environment.
The Sample Database
You will be accessing tables in the sample database for SQL/MX as you work through
the examples in this tutorial. A table consists of rows and columns. MXCI displays rows
horizontally and columns vertically. Columns have names, rows do not. Stored data is
retrieved and displayed in rows and columns.
•
Each row contains pieces of related data, such as the number of a part, its
description, price, and the quantity available.
•
Each column contains data of the same type, such as all part numbers.
Use the sample database to follow each lesson and perform the operations shown in
the examples. The results of your work should be similar to the results shown in the
examples.
The sample database consists of a catalog and three schemas:
•
The Quick Start examples use these tables in the sample database: PARTS Table,
ORDERS Table, ODETAIL Table, EMPLOYEE Table, and DEPT Table.
SAMDBCAT Sample database catalog.
PERSNL Contains the EMPLOYEE, JOB, DEPT, and PROJECT tables, which
are used to store personnel data.
SALES Contains the CUSTOMER, ORDERS, ODETAIL and PARTS tables,
which are used to store order data.
INVENT Contains the SUPPLIER, PARTSUPP, and PARTLOC tables, which
are used to store inventory data.