SQL/MX Programming Manual for Java

SQLJ Programming
HP NonStop SQL/MX Programming Manual for Java—523726-003
3-32
Data Type Support
Data Type Support
The subsection discusses the data types that are supported in SQLJ programs and
covers these topics:
•
Input Assignability on page 3-32
•
Output Assignability on page 3-35
•
Optimal Data Type Mappings on page 3-37
•
Date-Time Data Types on page 3-38
•
Interval Data Types on page 3-38
•
Floating-Point Data Types on page 3-39
•
Character String Data Types on page 3-40
For more information about SQL data types, see the SQL/MX Reference Manual and
the SQL/MP Reference Manual.
Input Assignability
The input assignability table shows the Java data types that you can use for inputting
data from input host variables and expressions to SQL column types.
Note. For better performance in OLTP environments, use the data type mappings shown in
Optimal Data Type Mappings on page 3-37.
Table 3-1. Input Assignability of Data Types (page1of3)
Java Wrapper Class Java Primitive Data Type
*
Maps to SQL Data Type...
java.lang.Boolean boolean CHAR[ACTER],
CHAR[ACTER] VARYING,
VARCHAR, PIC[TURE] X,
NATIONAL CHAR[ACTER],
NATIONAL CHAR[ACTER]
VARYING, NCHAR, NCHAR
VARYING
SMALLINT, INT[EGER],
LARGEINT, NUMERIC,
DEC[IMAL], PIC[TURE]
S9, REAL, FLOAT, DOUBLE
PRECISION
*
The Java primitive data types, such as boolean, byte, and int, have corresponding Java wrapper classes,
which are part of the java.lang package. Java primitive data types do not support null values. For more
information, see Null Values
on page 3-29.
**
The UnicodeStream type is deprecated in SQL/MX Release 2.x. Use CharacterStream instead.