SQL/MP Installation and Management Guide

Index
HP NonStop SQL/MP Installation and Management Guide—523353-004
Index-6
D
CREATE CATALOG statement
catalog description 1-3
description 7-2
PHYSVOL option 5-7
securing catalog tables 5-7
CREATE COLLATION statement 7-13
CREATE CONSTRAINT
statement 5-52/5-55, 7-12/7-14
CREATE INDEX statement
adding an index 7-4
description 5-42/5-47
invalidating programs 10-16
PHYSVOL option 5-45
Sort operations 14-26
uses 3-20
CREATE SYSTEM CATALOG
command 2-4, 2-5
CREATE TABLE statement
adding tables 7-3
altering columns, example 7-26
DEFINEs 10-34
description 5-10
guidelines 5-11/5-19
PHYSVOL option 5-18
CREATE VIEW statement 5-38/5-41, 7-4
Creation timestamp, similarity check
rules 10-27
CURRENTDEFINES option
COMPILE option 10-25
description 10-32
Cursor, name resolution 10-14
C-series to D-series migration 2-12
D
Daily backup 4-19
Data
appending to tables and partitions 8-15
block usage display 13-2
checking 1-6, 14-23
dropping 8-18
Data (continued)
integrity constraints 14-23
limiting access 3-15
partitioned 5-32
purging 8-18
replicated 12-10
unavailable, effects 10-12
validity 1-6
views and consistency 3-14
Data dictionary
See also Catalogs
active 1-3
constraints 1-4
effects 1-3
planning 1-3
querying 6-1
recovery EDIT files 4-24
Data types
ASCII 5-21
binary 5-22
character 5-20
date-time 5-20/5-25
DECIMAL 5-22
default column 5-26
DOUBLE PRECISION 5-22
FLOAT 5-22
guidelines 5-20
INTEGER 5-22
INTERVAL 5-23/5-25
LARGEINT 5-22
matching 5-29
NUMERIC 5-20, 5-22
performance issues 5-20
REAL 5-22
SMALLINT 5-22
VARCHAR 5-21
Database
access costs 13-10
access strategy 3-13