SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-4
C
Catalogs (continued)
resolution 10-13
node name change 9-32
number 5-5, 5-6
PUP LABEL issues 11-31
PUP RENAME issues 11-32
querying 6-1
recovering 11-12, 11-29
registering programs 10-7
RESETBROKEN option 11-11
RESTORE utility 11-2
restoring 11-2
single 5-5
SQL compilation 10-11
statistics 14-7
structure 5-3
table relationships 5-3
tables 5-2
TMF protection 11-2
upgrading 2-14
version information 6-15
CATALOGS catalog table
description
initializing 2-4
location 2-5
requirements 5-4
displaying contents 6-4
listing catalog names 9-33
moving 9-10
rebuilding 9-13
securing 5-7, 5-10
Catalog, system
See System catalog
Changing the database 7-1, 7-14
Character
column 5-27
data types 5-20
set 5-20
Character column 5-27
CHECK option
INOPERABLE PLANS option 10-16,
10-18
syntax 10-15
CLASS CATALOG DEFINE
example 10-34
name resolution 10-13
CLASS MAP DEFINE
example 10-34
name resolution 10-13
CLEANUP utility 11-36, B-1
CLEAR option, COMMENT statement 7-35
CLEARONPURGE attribute
altering 7-19
indexes 4-5
similarity rules 10-28
CLUSTERING KEY clause 3-2, 3-6
Clustering keys
combined with system-defined key 3-3
defining 5-11
description 3-2
example 5-12
key-sequenced files 3-6
Collating sequence, ASCII 5-20, 5-44
Collations
adding 7-13
altering attributes 7-27
creating 7-13
displaying information 6-6
dropping 7-34
security 5-59
Column headings, similarity check
rules 10-28
Columns
adding 7-10
altering 7-16
catalog statistics 14-7
data types 5-25
database integration 7-11
default value 5-26