NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-14
D
Date
computing for report C-57
, C-163
of expiration A-30
print item display format A-62
specifying default format D-8
DATE data type D-7
DATE literal D-10
DATE values
in host variables H-6
LOAD command L-37
DATEFORMAT function D-13
DATETIME
data syntax D-6
data type D-14
literals D-10
values, LOAD command L-37
Datetime values
inserting, example of I-19
DATETIMEENDFIELD in COLUMNS
table C-42
DATETIMEQUALIFIER in COLUMNS
table C-42
DATETIMESTARTFIELD in COLUMNS
table C-42
Date-time
arithmetic E-26
data types
description of D-8
TIME D-10
TIMESTAMP D-10
expressions
description of E-23
expressions, evaluation E-26
functions D-9
items, in expressions E-26
literals D-9
Date-time values
comparing C-54
in host variables H-6
inserting I-17, I-19
DATE_FORMAT layout option D-8, R-11
DAYOFWEEK function D-16
DCL statements
CONTROL EXECUTOR C-68
CONTROL QUERY C-69
CONTROL TABLE C-72
FREE RESOURCES F-30
LOCK TABLE L-41
UNLOCK TABLE U-1
DCL (Data Control Language)
statements D-16
DCOM utility U-18
DCOMPRESS file attribute
description of D-17
displaying F-18
DCOMPRESS, in FILES table F-28
DDL
alternate keys C-96
and database concurrency C-60, D-19
and HELP TEXT H-4
clauses, CONVERT statement C-97
data types, SQL equivalents L-35
groups, converting C-102
performance considerations C-128
primary key C-96
record definitions, Enscribe file C-96
security requirements S-16
statements D-19
DDL statements
ALTER CATALOG A-7
ALTER COLLATION A-9
ALTER INDEX A-12
ALTER PROGRAM A-25
ALTER TABLE A-27
ALTER VIEW A-45
COMMENT C-43
CREATE CATALOG C-127
CREATE COLLATION C-130
CREATE CONSTRAINT C-131