SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)
Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-2
A
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
syntax diagram of 3-6
ALLOCATE file attribute 8-2
ALLOW_DP2_ROW_SAMPLING
default 10-66
ALL_UIDS metadata table 10-8
ALTER DEFINE command
examples of 4-7
syntax diagram of 4-6
ALTER INDEX statement
ALLOCATE within 8-2
authorization and availability
requirements 2-9
CLEARONPURGE within 8-5
DEALLOCATE within 8-2
examples of 2-10
file attributes 2-9
MAXEXTENTS within 8-7
syntax diagram of 2-8
ALTER SQLMP ALIAS statement
examples of 2-11
syntax diagram of 2-10
ALTER TABLE statement
ALLOCATE within 8-2
AUDITCOMPRESS within 8-3
authorization and availability
requirements 2-25
CLEARONPURGE within 8-5
constraints implemented with
indexes 2-25
DEALLOCATE within 8-2
DEFAULT clause 7-2
examples of 2-35
MAXEXTENTS within 8-7
syntax diagram of 2-12
ALTER TRIGGER statement
authorization and availability
requirements 2-41
syntax diagram of 2-40
ANSI
compliance, default settings 1-33
compliance, description of 1-33
SQL standards E-1
standards, SQL/MX compliance E-2
ANSI names
alias mappings 1-26
ALTER SQLMP ALIAS statement 2-10
CREATE SQLMP ALIAS
statement 2-91
displaying with INFO 5-70
DROP SQLMP ALIAS statement 2-163
object naming 10-60
schemas 6-105
SQL/MP aliases 6-109
SQL/MP databases 1-25
SQL/MP objects 6-14, 6-16
SQL/MX objects 6-13
verifying with VERIFY 5-131
ANSI_STRING_FUNCTIONALITY
default 10-52
ASCII function
examples of 9-11
syntax diagram of 9-11
ASIN function
examples of 9-12
syntax diagram of 9-12
Assignment statement
examples of 3-77
syntax diagram of 3-76
ASSOC2DS metadata table 10-94
ATAN function
examples of 9-13
syntax diagram of 9-13










