SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

HP NonStop SQL/MX Reference Manual—640322-001
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-118
DML statements use of 1-7
INSERT statement use of 2-169
READ COMMITTED 1-8
READ UNCOMMITTED 1-8
REPEATABLE READ 1-8
SELECT statement use of 2-212
SERIALIZABLE 1-8, 1-10, 1-22
SKIP CONFLICT 1-8
SQL/MP considerations 1-30
STABLE 1-9
UPDATE statement use of 2-257
Access privileges
ALL PRIVILEGES 2-162
DELETE 2-162
INSERT 2-162
REFERENCES 2-162
SELECT 2-162
tables 2-162
UPDATE 2-162
views 2-162, 2-164
ACCESS_PATHS metadata table 10-11
ACCESS_PATH_COLS metadata
table 10-13
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-204
Aggregate functions
summary of 9-1
AVG 9-14
COUNT 9-35
DISTINCT clause 2-217, 9-2
MAX 9-89
MIN 9-90
STDDEV 9-153
SUM 9-158
VARIANCE 9-180
Aliases
ALTER SQLMP ALIAS statement 2-8
catalogs 10-58
CREATE SQLMP ALIAS
statement 2-73
description of 6-109
DROP SQLMP ALIAS statement 2-132
for super IDs executing privileged
utilities 5-2
OBJECTS table 6-15
schemas 6-105
ALL PRIVILEGES access privilege 2-162,
2-191
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