SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Index
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
Index-9
D
MINUTE 8-105
MONTH 8-107
MONTHNAME 8-108
QUARTER 8-133
SECOND 8-167
WEEK 8-212
YEAR 8-213
Datetime literals
description of 6-68
inserting into SQL/MP columns 6-69
selecting from SQL/MP tables 6-28
Datetime value expression
examples of 6-44
syntax diagram of 6-43
DAY function
examples of 8-50
syntax diagram of 8-50
DAYNAME function
examples of 8-51
syntax diagram of 8-51
DAYOFMONTH function
examples of 8-52
syntax diagram of 8-52
DAYOFWEEK function
examples of 8-53
syntax diagram of 8-53
DAYOFYEAR function
examples of 8-54
syntax diagram of 8-54
DDL statements
See Data Definition Language (DDL)
statements
DDL_DEFAULT_LOCATIONS
default 10-63, 10-67
DDL_LOCKS metadata table 10-21
DDL_PARTITION_LOCKS metadata
table 10-21
DEALLOCATE DESCRIPTOR statement
examples of 3-17
syntax diagram of 3-16
DEALLOCATE file attribute 9-2
DEALLOCATE PREPARE statement
C examples of 3-19
COBOL examples of 3-20
syntax diagram of 3-18
DECIMAL data type 6-36
DECLARE CATALOG declaration
C examples of 3-21
COBOL examples of 3-21
scope of 3-21
syntax diagram of 3-21
DECLARE CURSOR declaration
C examples of 3-25
COBOL examples of 3-26
default for updatability 3-24
Publish/Subscribe examples of 3-5,
3-28
query expression within 3-23
specifying read-only cursor 3-23
specifying updatable cursor 3-23
static and dynamic forms 3-22
syntax diagram of 3-22
WITH HOLD clause 3-23
WITH HOLD limitations 3-25
DECLARE MPLOC declaration
C examples of 3-30
COBOL examples of 3-31
scope of 3-30
syntax diagram of 3-29
DECLARE NAMETYPE declaration
C examples of 3-32
COBOL examples of 3-32
scope of 3-32
syntax diagram of 3-32
DECLARE SCHEMA declaration
C examples of 3-33
COBOL examples of 3-33
scope of 3-33
syntax diagram of 3-33
DEFAULT clause