SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-1
Index
Numbers
14139
H1 heading
DEGREES Function 8-55
36781
H1 heading
POSITION Function 8-89
A
ABS function
examples of 8-10
syntax diagram of 8-10
Access options
summary of 1-8
DELETE statement use of 2-165
DML statements use of 1-8
INSERT statement use of 2-252
READ COMMITTED 1-9
READ UNCOMMITTED 1-9
REPEATABLE READ 1-9
SELECT statement use of 2-344
SERIALIZABLE 1-9, 1-11, 1-24
SKIP CONFLICT 1-9
SQL/MP considerations 1-32
STABLE 1-10
UPDATE statement use of 2-389
Access privileges
ALL PRIVILEGES 2-241
DELETE 2-241
INSERT 2-241
REFERENCES 2-241
SELECT 2-241
tables 2-3, 2-240
UPDATE 2-241
views 2-3, 2-240, 2-244
ACCESS_PATHS metadata table 10-12
ACCESS_PATH_COLS metadata
table 10-14
ACOS function
examples of 8-10
syntax diagram of 8-10
ADD DEFINE command
examples of 4-5
syntax diagram of 4-4
AFTER LAST ROW clause 2-336
Aggregate functions
summary of 8-1
AVG 8-14
COUNT 8-38
DISTINCT clause 2-349, 8-2
MAX 8-103
MIN 8-104
STDDEV 8-171
SUM 8-176
VARIANCE 8-207
Aliases
ALTER SQLMP ALIAS statement 2-17
catalogs 10-61
CREATE SQLMP ALIAS
statement 2-104
description of 6-112
DROP SQLMP ALIAS statement 2-188
OBJECTS table 6-15
schemas 6-107
ALL PRIVILEGES access privilege 2-241,
2-318
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
WITH HOLD limitations 3-4
ALLOCATE DESCRIPTOR statement