NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-10
C
BIND NAMES option C-70
description of C-69
HASH JOIN option C-70
INTERACTIVE ACCESS option C-71
MDAM option C-71
CONTROL TABLE directive
ACCESS PATH option C-74
and BIND NAMES option C-70
description of C-72
displaying current values S-49
in EXPLAIN report E-17
JOIN METHOD option C-75
JOIN SEQUENCE option C-76
lock waits C-77
MDAM option C-76
OPEN option C-76
RETURN IF LOCKED option C-77
SEQUENTIAL BLOCKSPLIT
option C-77
SEQUENTIAL option C-77
SKIP option C-78
STOP AT option C-78
SYNCDEPTH option C-79
TABLELOCK option C-79
TIMEOUT option C-79
UNAVAILABLE PARTITION
option C-78
with LOCK TABLE statement L-42
Controlling the SORTPROG process S-25
Conversational interface
See SQLCI
CONVERT command
alternate key specification C-96
authorization requirement C-95
behavior C-95
CATALOG option C-92
CHARACTER option C-94
COMMENTS option C-92
conversion of DDL items with C-98
DDL groups C-93, C-102, C-103
description of C-89
DICTIONARY option C-93
Enscribe files C-96
file attributes of tables and
indexes C-102
FILE IS option C-93
LOAD option C-93
MAP NAME option C-91
NATIONAL option C-94
PART option C-93
partition attributes of objects C-102
primary key specification C-96
REDEFINE option C-94
SOURCE option C-93
VARCHARS option C-93
Converted Enscribe applications
and RETURN IF LOCKED
option C-77
Converting
an Enscribe file to an SQL table C-89
binary data types C-99
DDL character strings C-99
DDL elementary items C-98
DDL groups C-101
decimal data types C-100
Enscribe applications C-77
Enscribe file to SQL table L-36
FORTRAN data types C-100
SQL table to Enscribe file L-36
variable-length strings C-101
CONVERTTIMESTAMP function C-109
Copies of report O-9
COPY command
ALLOWERRORS option C-112
BLOCKOUT option C-114
compared to APPEND A-50
compared to LOAD C-118
COUNT option C-112