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

HP NonStop SQL/MX Installation and Management Guide—523723-004
Index-1
Index
A
ABORT DISK command, SCF 12-36
Access paths
alternate 7-31
clustering key 7-31
Access privileges for SQL/MX objects 7-9
Accessing an SQL/MP database from
SQL/MX 7-1
ADD COLUMN clause 7-21
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-15
Adding tables 9-15
Adding triggers 9-16
Adding views 9-17
Aliases
adding 9-14
altering 9-21
dropping 9-35
for the InstallSqlmx script 3-25
ALLOCATE attribute
altering index attributes 9-20
altering table attributes 9-24
ALTER DISK command, SCF 12-36
ALTER DISK, LABEL command,
SCF 12-37
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-24
table columns 7-21
Altering aliases 9-21
Altering columns 9-23
Altering constraints 9-24
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-24
example of 9-25
Altering table privileges 9-25
Altering tables 9-22
Altering triggers 9-25
Altering views 9-26
Alternate access path 7-31
ANSI compliance, defaults 6-12
ANSI names for SQL/MP objects 1-8
ANSI names for SQL/MX objects 1-6
Applications
assigning permissions for files in
Guardian space 11-13
assigning permissions for files in OSS
space 11-13