SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-9
C
Compatible data types and INSERT I-16
Compilation
authority for S-15
automatic P-29
explicit P-29
Guardian command for S-67
OSS command for C-176
time D-52
Compiler event messages Z-11
Compilers
and statistics U-9
host language, versions V-8
NonStop SQL/MP, versions V-6
Components, versions of V-6
COMPUTE_TIMESTAMP function
and report writer R-11
description of C-62
SET PARAM command S-36
CONCAT clause
description of C-63
report writer option R-10
Concurrency
affect of access options A-3
and buffering C-88
DDL and DML statements C-65
DDL statements D-21
description of C-65
effect of access options A-1
effect of VSBB C-68, C-89
utility operations C-68
Conditional
display format A-64
page break D-48
printing of items I-1
Conditions for grouped rows S-21
Conditions for selecting data S-5
Configuration file
CREATE INDEX statement P-5
CREATEINDEX keyword P-6
Consistency, effect of access options A-1
Constraint
catalog description of C-70
CREATE CONSTRAINT
statement C-139
description of C-69
DROP statement D-64
text limit L-7
versions V-7
CONSTRAINTNAME, in CONSTRNT
table C-70
CONSTRAINTS, in BASETABS table B-1
CONSTRAINTTEXT, in CONSTRNT
table C-70
CONSTRNT catalog table C-70
Continuation prompt S-60
CONTINUE statement C-70
CONTROL EXECUTOR directive C-73
Control options, displaying S-48
CONTROL QUERY directive
BIND NAMES option C-74
description of C-74
HASH JOIN option C-75
INTERACTIVE ACCESS option C-75
MDAM option C-75
control statements C-76
CONTROL TABLE directive
ACCESS PATH option C-79
and BIND NAMES option C-74
description of C-77
displaying current values S-48
in EXPLAIN report E-16
JOIN METHOD option C-80
JOIN SEQUENCE option C-81
lock waits C-82
MDAM option C-81
OPEN option C-82
RETURN IF LOCKED option C-82
SEQUENTIAL BLOCKSPLIT
option C-83
SEQUENTIAL option C-82
SKIP option C-83