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

Index
HP NonStop SQL/MX Quick Start—540438-001
Index-3
T
SELECT statement (continued)
retrieving data with 2-1
rows
in ascending order 2-7
in descending order 2-7
SELECT * 2-1, 2-2
WHERE clause 2-2
Selected columns 2-2
Selected rows 2-2
Selecting all data 2-1
Set functions
AVG 4-1
COUNT 4-1
COUNT(*) 4-1
MIN 4-1
SUM 4-1
SET list 6-2
SET PARAM command 7-2
setmxdb script 1-9
Single quotes 2-3
SQL 1-1
SQLCI 1-1
SQL/MP tables, working with 2-1
SQL/MX conversational interface
(MXCI) 1-1
SQL/MX Release 1.8 1-9
SQL/MX Release 2.x 1-3
Starting a transaction 8-1
T
Table
creating a 9-2
dropping a 9-4
Transaction
audited tables 8-2
automatic 8-2
BEGIN WORK statement 8-1
COMMIT WORK statement 8-1
defining 8-1
ending 8-2
Transaction (continued)
ROLLBACK WORK statement 8-1
starting 8-1
U
UPDATE statement 6-2
Updating rows 6-2
UPSHIFT function 2-3, 3-2
V
View
creating a 9-3
dropping a 9-4
W
WHERE clause 2-2
Wild-card characters 3-2
Special Characters
(EXPR) 2-4