SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-1
Index
Numbers
14139
H1 heading
DEGREES Function 9-50
36781
H1 heading
POSITION Function 9-84
A
ABS function
examples of 9-10
syntax diagram of 9-10
Access options
summary of 1-8
DELETE statement use of 2-149
DML statements use of 1-8
INSERT statement use of 2-209
READ COMMITTED 1-9
READ UNCOMMITTED 1-9
REPEATABLE READ 1-9
SELECT statement use of 2-256
SERIALIZABLE 1-9, 1-11, 1-23
SKIP CONFLICT 1-9
SQL/MP considerations 1-31
STABLE 1-10
UPDATE statement use of 2-301
Access privileges
ALL PRIVILEGES 2-198
DELETE 2-198
INSERT 2-198
REFERENCES 2-198
SELECT 2-198
tables 2-3, 2-198
UPDATE 2-198
views 2-3, 2-198, 2-200
ACCESS_PATHS metadata table 10-12
ACCESS_PATH_COLS metadata
table 10-14
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-248
Aggregate functions
summary of 9-1
AVG 9-14
COUNT 9-38
DISTINCT clause 2-261, 9-2
MAX 9-98
MIN 9-99
STDDEV 9-166
SUM 9-171
VARIANCE 9-202
Aliases
ALTER SQLMP ALIAS statement 2-10
catalogs 10-61
CREATE SQLMP ALIAS
statement 2-91
description of 6-109
DROP SQLMP ALIAS statement 2-163
for super IDs executing privileged
utilities 5-3
OBJECTS table 6-15
schemas 6-105
ALL PRIVILEGES access privilege 2-198,
2-232
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