SQL/MX 2.x Reference Manual (H06.04+)

HP NonStop SQL/MX Reference Manual—540440-003
Index-1
Index
A
ABS function
examples of 9-10
syntax diagram of 9-10
Access options
summary of 1-7
DELETE statement use of 2-111
DML statements use of 1-7
INSERT statement use of 2-145
READ COMMITTED 1-8
READ UNCOMMITTED 1-8
REPEATABLE READ 1-8
SELECT statement use of 2-188
SERIALIZABLE 1-8, 1-10, 1-22
SKIP CONFLICT 1-8
SQL/MP considerations 1-30
STABLE 1-9
UPDATE statement use of 2-230
Access privileges
ALL PRIVILEGES 2-138
DELETE 2-138
INSERT 2-138
REFERENCES 2-138
SELECT 2-138
tables 2-138
UPDATE 2-138
views 2-138, 2-140
ACCESS_PATHS metadata table 10-11
ACCESS_PATH_COLS metadata
table 10-12
ACOS function
examples of 9-10
syntax diagram of 9-10
ADD DEFINE command
examples of 4-4
syntax diagram of 4-3
AFTER LAST ROW clause 2-180
Aggregate functions
summary of 9-1
AVG 9-14
COUNT 9-32
DISTINCT clause 2-193, 9-2
MAX 9-81
MIN 9-82
STDDEV 9-142
SUM 9-147
VARIANCE 9-166
Aliases
ALTER SQLMP ALIAS statement 2-8
catalogs 10-49
CREATE SQLMP ALIAS
statement 2-70
description of 6-105
DROP SQLMP ALIAS statement 2-125
for super IDs executing privileged
utilities 5-2
OBJECTS table 6-14
schemas 6-101
ALL PRIVILEGES access privilege 2-138,
2-167
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
C examples of 3-7
COBOL examples of 3-8
defining values in SQL descriptor
area 3-7
naming SQL descriptor area 3-7
specifying size of SQL descriptor
area 3-6