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

Index
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
Index-8
D
Data Manipulation Language (DML)
statements
summary of 2-3
DELETE statement 2-147
INSERT statement 2-209
SELECT statement 2-242
UPDATE statement 2-297
Data type conversion, CAST
expression 9-20
Data types
and SPJ methods 2-81
approximate numeric
descriptions of 6-35
DOUBLE PRECISION 6-37
FLOAT 6-36
REAL 6-37
character 6-22
comparable and compatible 6-17
datetime
DATE 6-26
TIME 6-26
TIMESTAMP 6-26
exact numeric
DECIMAL 6-36
descriptions of 6-35
INTEGER 6-35
LARGEINT 6-36
NUMERIC 6-35
PICTURE 6-36
SMALLINT 6-35
extended numeric precision 6-18
fixed length character
CHAR 6-23
NATIONAL CHAR 6-23
NCHAR 6-23
PIC 6-23
interval 6-31
Java 2-81
literals, examples of
character string literals 6-67
datetime literals 6-70
interval literals 6-75
numeric literals 6-76
varying-length character
CHAR VARYING 6-23
NATIONAL CHAR VARYING 6-23
NCHAR VARYING 6-23
VARCHAR 6-23
Database object names 6-13
Database object namespace 6-15
Database objects 6-12
Database sample tables D-1
DATASOURCES metadata table 10-95
DATA_FLOW_OPTIMIZATION
default 10-67
DATEFORMAT function
examples of 9-44
syntax diagram of 9-44
Datetime data types
DATE 6-26
description of 6-26
examples of literals 6-70
MP DATETIME data 6-29
TIME 6-26
TIMESTAMP 6-26
Datetime functions
summary of 9-4
CONVERTTIMESTAMP 9-36
CURRENT_DATE 9-41
CURRENT_TIME 9-42
CURRENT_TIMESTAMP 9-43
DATEFORMAT 9-44
DAY 9-45
DAYNAME 9-46
DAYOFMONTH 9-47
DAYOFWEEK 9-48
DAYOFYEAR 9-49
EXTRACT 9-70
HOUR 9-78
JULIANTIMESTAMP 9-80