SQL/MX Quick Start (H06.04+, J06.03+)

Hewlett-Packard Company—540438-001
i
HP NonStop SQL/MX Quick
Start
Glossary Index
What’s New in This Manual v
Manual Information v
New and Changed Information v
About This Manual vii
Audience vii
Related Documentation viii
Notation Conventions xi
1. Welcome to MXCI and the Sample Database
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-4
ODETAIL Table 1-4
EMPLOYEE Table
1-4
DEPT Table
1-5
Installing the setmxdb Script 1-5
Installing or Removing the Sample Database 1-6
Using a SQL/MX Release 1.8 setmxdb Script in a SQL/MX Release 2.x
Environment 1-9
Installing the SQL/MP Sample Database 1-10
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