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

Index
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
Index-8
D
SIGNAL SQLSTATE 2-306
Data Manipulation Language (DML)
statements
summary of 2-4
DELETE statement 2-150
INSERT statement 2-217
SELECT statement 2-255
UPDATE statement 2-310
Data type conversion, CAST
expression 9-20
Data types
and SPJ methods 2-82
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-82
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-98
DATA_FLOW_OPTIMIZATION
default 10-69
DATEDIFF Function 9-46
DATEFORMAT function
examples of 9-48
syntax diagram of 9-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 9-4
CONVERTTIMESTAMP 9-36
CURRENT_DATE 9-41
CURRENT_TIME 9-42
CURRENT_TIMESTAMP 9-43
DATEFORMAT 9-48
DAY 9-50
DAYNAME 9-51
DAYOFMONTH 9-52
DAYOFWEEK 9-53
DAYOFYEAR 9-54
EXTRACT 9-75