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

Index
HP NonStop SQL/MX Quick Start—540438-001
Index-2
L
L
LIKE predicate 3-1, 3-2, 3-3
Logical operators
AND 3-3
NOT 3-4, 3-5
OR 3-3
sequence of evaluation 3-4
M
MXCI
entering command 1-2
starting session 1-1
stopping session 1-2
N
NO DEFAULT 2-5
NOT NULL 2-5
NOT operator 3-1, 3-4
NULL predicate 3-1
Numeric data 2-5
O
ODETAIL table 1-3
OR operator 3-3
ORDER BY 1 4-2
ORDER BY clause 2-6
Ordered groups of rows 4-2
ORDERS table 1-3
P
Parameter
names 7-2
values 7-2
PARTS table 1-3
Predicates 3-1
PREPARE statement 7-1
Primary key 6-2
Q
Qualifying table names 5-2
R
Removing the sample database 1-6
ROLLBACK WORK statement 8-1
Rows
counting 4-4
deleting 6-3
inserting 6-1
selected 2-2
updating 6-2
S
Sample database
DEPT table 1-5
EMPLOYEE table 1-4
installing 1-6
INVENT subvolume 1-3
ODETAIL table 1-4
ORDERS table 1-4
PARTS table 1-3
PERSNL subvolume 1-3
removing 1-6
SALES subvolume 1-3
SQL/MP tables 1-3, 1-9, 1-10
SQL/MX tables 1-3
SELECT statement
arithmetic operators 2-4
AS clause 2-4
calculated values 2-3
column names 2-2
DISTINCT rows 2-5
FROM clause 2-2
GROUP BY clause 4-2
HAVING clause 4-5
ORDER BY clause 2-6
predicates 3-1