SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-1
Numbers
Index
Numbers
14139
H1 heading
DEGREES Function 9-55
36781
H1 heading
POSITION Function 9-89
A
ABS function
examples of 9-10
syntax diagram of 9-10
Access options
summary of 1-9
DELETE statement use of 2-153
DML statements use of 1-9
INSERT statement use of 2-217
READ COMMITTED 1-10
READ UNCOMMITTED 1-10
REPEATABLE READ 1-10
SELECT statement use of 2-269
SERIALIZABLE 1-10, 1-12, 1-24
SKIP CONFLICT 1-10
SQL/MP considerations 1-32
STABLE 1-11
UPDATE statement use of 2-314
Access privileges
ALL PRIVILEGES 2-206
DELETE 2-206
INSERT 2-206
REFERENCES 2-206
SELECT 2-206
tables 2-3, 2-205
UPDATE 2-206
views 2-3, 2-205, 2-208
ACCESS_PATHS metadata table 10-13
ACCESS_PATH_COLS metadata
table 10-15
ACOS function
examples of 9-10
syntax diagram of 9-10
ADD DEFINE command
examples of 4-5
syntax diagram of 4-4
AFTER LAST ROW clause 2-261
Aggregate functions
summary of 9-1
AVG 9-14
COUNT 9-38
DISTINCT clause 2-274, 9-2
MAX 9-103
MIN 9-104
STDDEV 9-171
SUM 9-176
VARIANCE 9-207
Aliases
ALTER SQLMP ALIAS statement 2-10
catalogs 10-62
CREATE SQLMP ALIAS
statement 2-92
description of 6-109
DROP SQLMP ALIAS statement 2-170
for super IDs executing privileged
utilities 5-3
OBJECTS table 6-15
schemas 6-105
ALL PRIVILEGES access privilege 2-206,
2-244
ALLOCATE CURSOR statement
C examples of 3-4
COBOL examples of 3-5
naming cursor 3-4
syntax diagram of 3-3
WITH HOLD clause 3-3