SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

HP NonStop SQL/MX Reference Manual—544517-008
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-117
DML statements use of 1-7
INSERT statement use of 2-168
READ COMMITTED 1-8
READ UNCOMMITTED 1-8
REPEATABLE READ 1-8
SELECT statement use of 2-211
SERIALIZABLE 1-8, 1-10, 1-22
SKIP CONFLICT 1-8
SQL/MP considerations 1-30
STABLE 1-9
UPDATE statement use of 2-254
Access privileges
ALL PRIVILEGES 2-161
DELETE 2-161
INSERT 2-161
REFERENCES 2-161
SELECT 2-161
tables 2-161
UPDATE 2-161
views 2-161, 2-163
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-203
Aggregate functions
summary of 9-1
AVG 9-14
COUNT 9-35
DISTINCT clause 2-216, 9-2
MAX 9-85
MIN 9-86
STDDEV 9-146
SUM 9-151
VARIANCE 9-170
Aliases
ALTER SQLMP ALIAS statement 2-8
catalogs 10-52
CREATE SQLMP ALIAS
statement 2-75
description of 6-106
DROP SQLMP ALIAS statement 2-131
for super IDs executing privileged
utilities 5-2
OBJECTS table 6-15
schemas 6-102
ALL PRIVILEGES access privilege 2-161,
2-190
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