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

Hewlett-Packard Company523724-002
i
HP NonStop SQL/MX Quick
Start
Index
What’s New in This Manual v
Manual Information v
New and Changed Information v
About This Manual vii
Audience vii
Related Documentation vii
Notation Conventions x
1. Welcome to Quick Start
What Is MXCI? 1-1
Using MXCI 1-1
Starting MXCI 1-1
Entering a Command 1-2
Stopping MXCI 1-2
The Sample Database 1-2
PARTS Table 1-3
ORDERS Table 1-3
ODETAIL Table 1-3
EMPLOYEE Table
1-4
DEPT Table
1-4
Installing the setmxdb Script 1-4
Installing or Removing the Sample Database 1-5
Using a SQL/MX Release 1.8 setmxdb Script in the SQL/MX Release 2.0
Environment 1-8
2. Selecting Information From a Table
Working With SQL/MP Tables 2-1
Selecting All the Data From a Table 2-1
Displaying Selected Columns. 2-2
Displaying Selected Rows 2-2
Displaying Calculated Values 2-3
Displaying Descriptions of Columns 2-4