SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

HP NonStop SQL/MX Reference Manual—523725-004
Index-1
Index
A
ABS function
examples of 9-10
syntax diagram of 9-10
Access options
summary of 1-6
DELETE statement use of 2-112
DML statements use of 1-6
INSERT statement use of 2-149
READ COMMITTED 1-7
READ UNCOMMITTED 1-7
REPEATABLE READ 1-7
SELECT statement use of 2-192
SERIALIZABLE 1-7
SKIP CONFLICT 1-8
SQL/MP considerations 1-28
STABLE 1-8
UPDATE statement use of 2-235
Access privileges
ALL PRIVILEGES 2-141
DELETE 2-141
INSERT 2-141
REFERENCES 2-141
SELECT 2-141
tables 2-141
UPDATE 2-141
views 2-141, 2-143
ACCESS_PATHS metadata table 10-10
ACCESS_PATH_COLS metadata
table 10-11
ACOS function
examples of 9-11
syntax diagram of 9-11
ADD DEFINE command
examples of 4-4
syntax diagram of 4-3
AFTER LAST ROW clause 2-184
Aggregate functions
summary of 9-1
AVG 9-16
COUNT 9-35
DISTINCT clause 2-197, 9-2
MAX 9-81
MIN 9-82
STDDEV 9-147
SUM 9-152
VARIANCE 9-173
Aliases
ALTER SQLMP ALIAS statement 2-9
catalogs 10-48
CREATE SQLMP ALIAS
statement 2-71
description of 6-108
DROP SQLMP ALIAS statement 2-128
for super IDs executing privileged
utilities 5-2
OBJECTS table 6-14
schemas 6-104
ALL PRIVILEGES access privilege 2-141,
2-171
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