SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

HP NonStop SQL/MX Installation and Management Guide—544536-007
Index-1
Index
A
ABORT DISK command, SCF 12-37
Access paths
alternate 7-33
clustering key 7-33
Access privileges for SQL/MX objects 7-10
ADD COLUMN clause 7-23
ADD DUMPS TMF command 5-15
Adding aliases 9-14
Adding catalogs 9-4
Adding columns
description of 9-5
example of 9-7
Adding constraints 9-7
Adding indexes 9-8
Adding objects
authorization requirements 9-3
summary 9-2
Adding partitions
description of 9-11
example of 9-13
Adding schemas 9-13
Adding SQL/MP aliases 9-14
Adding stored procedures 9-14
Adding tables 9-14
Adding triggers 9-16
Adding views 9-17
Aliases
adding 9-14
altering 9-21
dropping 9-33
for the InstallSqlmx script 3-19
ALLOCATE attribute
altering index attributes 9-20
altering table attributes 9-24
ALTER DISK command, SCF 12-38
ALTER DISK, LABEL command,
SCF 12-39
ALTER DUMPS TMF command 5-15,
12-10
ALTER INDEX statement, altering
attributes 9-20
ALTER TABLE statement
adding column example 9-7
altering attributes 9-23
table columns 7-23
Altering aliases 9-21
Altering columns 9-22
Altering constraints 9-23
Altering indexes
description of 9-20
example of 9-20
Altering objects
authorization requirements 9-19
summary 9-18
Altering partitions 9-21
Altering SQL/MP aliases 9-21
Altering stored procedures 9-22
Altering system defaults 9-22
Altering table attributes
description of 9-23
example of 9-24
Altering table privileges 9-25
Altering tables 9-22
Altering triggers 9-25
Altering views 9-25
Alternate access path 7-33
ANSI compliance, defaults 6-13
ANSI names for SQL/MP objects 1-8
ANSI names for SQL/MX objects 1-6
ANSI names for tables and indexes in FUP
commands 1-15, 8-13, 10-3
Applications
assigning permissions for files in
Guardian space 11-13
assigning permissions for files in OSS
space 11-12