NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-12
C
CREATE statements and concurrent DML
operations C-61
CREATE SYSTEM CATALOG
command C-142
CREATE TABLE statement
AUDITCOMPRESS file
attribute C-149
CATALOG option C-147
CLUSTERING KEY clause C-147
DEFAULT clause C-146, D-24
description of C-143
file attributes C-149
HEADING clause C-146, H-1
LIKE clause C-145
NOT NULL clause C-146
ORGANIZATION clause C-148
PARTITION ARRAY clause C-148
PARTITION clause C-148
PHYSVOL clause C-147
PRIMARY KEY clause C-147
SECURE file attribute C-149
SIMILARITY CHECK clause C-149
CREATE VIEW statement
AS clause C-157
CATALOG clause C-158
CHECK C-158
description of C-156
FOR PROTECTION clause C-158
HEADING clause C-157, H-1
length of C-159
SECURE file attribute C-158
SELECT DISTINCT clause S-68
SIMILARITY CHECK clause C-158
WITH CHECK OPTION clause C-158
WITH HEADINGS clause C-158
WITH HELP TEXT clause C-159
CREATEINDEX keyword, configuration
file P-6
CREATETIME
in INDEXES table I-10
in PROGRAMS table P-30
in TABLES table T-2
Creating
catalog C-127
CATALOGS table C-142
collation C-130
constraint C-131
index C-133
table C-143
view C-156
CTOEDIT command F-9
Current default catalog Z-2
CURRENT default value D-25
Current default volume and subvolume Z-2
CURRENT function C-162
CURRENT_TIMESTAMP function
and report writer R-12
description of C-163
in USING clause, EXECUTE
statement E-8
SET param command S-36
Cursors
CLOSE statement C-25
closing C-25
declaration D-22
description of C-164
effect of FREE RESOURCES
statement F-30
execution time C-70
FETCH statement F-3, F-4
limits L-7
OPEN statement O-5
operations with VSBB C-86
position D-38
position of C-165
stability C-165
updating by position U-4