SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Index
HP NonStop SQL/MX Reference Manual—523725-004
Index-8
D
Data types (continued)
SMALLINT 6-34
fixed length character 6-21
interval 6-16, 6-30
Java 2-63
literals, examples of
character string literals 6-65
datetime literals 6-68
interval literals 6-73
numeric literals 6-75
SQL/MX 2-63
varying length character 6-21
Database object names 6-12
Database object namespace 6-14
Database objects 6-11
Database sample tables D-1
DATASOURCES metadata table 10-78
DATA_FLOW_OPTIMIZATION
default 10-53
DATEFORMAT function
examples of 9-42
syntax diagram of 9-42
Datetime data types
DATE 6-24
description of 6-24
examples of literals 6-68
MP DATETIME data 6-27
TIME 6-24
TIMESTAMP 6-24
Datetime functions
summary of 9-4
CONVERTTIMESTAMP 9-32
CURRENT_DATE 9-38
CURRENT_TIME 9-39
CURRENT_TIMESTAMP 9-40
DATEFORMAT 9-42
DAY 9-43
DAYNAME 9-44
DAYOFMONTH 9-45
DAYOFWEEK 9-46
Datetime functions (continued)
DAYOFYEAR 9-47
EXTRACT 9-62
HOUR 9-64
JULIANTIMESTAMP 9-66
MINUTE 9-83
MONTH 9-85
MONTHNAME 9-86
QUARTER 9-108
SECOND 9-140
WEEK 9-178
YEAR 9-179
Datetime literals
description of 6-65
inserting into SQL/MP columns 6-66
selecting from SQL/MP tables 6-26
Datetime value expression
examples of 6-42
syntax diagram of 6-41
DAY function
examples of 9-43
syntax diagram of 9-43
DAYNAME function
examples of 9-44
syntax diagram of 9-44
DAYOFMONTH function
examples of 9-45
syntax diagram of 9-45
DAYOFWEEK function
examples of 9-46
syntax diagram of 9-46
DAYOFYEAR function
examples of 9-47
syntax diagram of 9-47
DDL statements
See Data Definition Language (DDL)
statements
DDL_DEFAULT_LOCATIONS
default 10-50
DDL_LOCKS metadata table 10-17