SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-9
D
HOUR 9-83
JULIANTIMESTAMP 9-85
MINUTE 9-105
MONTH 9-107
MONTHNAME 9-108
QUARTER 9-133
SECOND 9-167
WEEK 9-212
YEAR 9-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 9-50
syntax diagram of 9-50
DAYNAME function
examples of 9-51
syntax diagram of 9-51
DAYOFMONTH function
examples of 9-52
syntax diagram of 9-52
DAYOFWEEK function
examples of 9-53
syntax diagram of 9-53
DAYOFYEAR function
examples of 9-54
syntax diagram of 9-54
DDL statements
See Data Definition Language (DDL)
statements
DDL_DEFAULT_LOCATIONS
default 10-65
, 10-69
DDL_LOCKS metadata table 10-22
DDL_PARTITION_LOCKS metadata
table 10-22
DEALLOCATE DESCRIPTOR statement
examples of 3-17
syntax diagram of 3-16
DEALLOCATE file attribute 8-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