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-8
D
summary of 2-4
DELETE statement 2-162
INSERT statement 2-252
SELECT statement 2-330
UPDATE statement 2-385
Data type conversion, CAST
expression 8-20
Data types
and SPJ methods 2-90
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-90
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-96
DATA_FLOW_OPTIMIZATION
default 10-67
DATEDIFF Function 8-46
DATEFORMAT function
examples of 8-48
syntax diagram of 8-48
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 8-4
CONVERTTIMESTAMP 8-36
CURRENT_DATE 8-41
CURRENT_TIME 8-42
CURRENT_TIMESTAMP 8-43
DATEFORMAT 8-48
DAY 8-50
DAYNAME 8-51
DAYOFMONTH 8-52
DAYOFWEEK 8-53
DAYOFYEAR 8-54
EXTRACT 8-75
HOUR 8-83
JULIANTIMESTAMP 8-85