SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-9
D
MINUTE 9-100
MONTH 9-102
MONTHNAME 9-103
QUARTER 9-128
SECOND 9-162
WEEK 9-207
YEAR 9-208
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-45
syntax diagram of 9-45
DAYNAME function
examples of 9-46
syntax diagram of 9-46
DAYOFMONTH function
examples of 9-47
syntax diagram of 9-47
DAYOFWEEK function
examples of 9-48
syntax diagram of 9-48
DAYOFYEAR function
examples of 9-49
syntax diagram of 9-49
DDL statements
See Data Definition Language (DDL)
statements
DDL_DEFAULT_LOCATIONS
default 10-63
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 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
syntax diagram of 3-33
DEFAULT clause