SQL/MX Programming Manual for Java

SQLJ Programming
HP NonStop SQL/MX Programming Manual for Java—523726-003
3-34
Input Assignability
java.lang.Short
java.lang.Integer
java.lang.Long
java.math.BigDecimal
java.lang.Float
java.lang.Double
short
int
long
float
double
SMALLINT, INT[EGER],
LARGEINT, NUMERIC,
DEC[IMAL], PIC[TURE]
S9, REAL, FLOAT, DOUBLE
PRECISION
CHAR[ACTER],
CHAR[ACTER] VARYING,
VARCHAR, PIC[TURE] X,
NATIONAL CHAR[ACTER],
NATIONAL CHAR[ACTER]
VARYING, NCHAR, NCHAR
VARYING
sqlj.runtime.
AsciiStream
sqlj.runtime.
CharacterStream
**
sqlj.runtime.
BinaryStream
CHAR[ACTER],
CHAR[ACTER] VARYING,
VARCHAR, PIC[TURE] X,
NATIONAL CHAR[ACTER],
NATIONAL CHAR[ACTER]
VARYING, NCHAR, NCHAR
VARYING
Note. If a floating-point number from a host variable is inserted into an SQL integer column
and the value of the floating-point number is larger than the column, an overflow occurs, no
exception is raised, and the maximum allowable value for the integer type (for example,
MAX_VALUE of java.lang.Short, java.lang.Integer, or java.lang.Long) is inserted
into the column. For other considerations, see Floating-Point Data Types
on page 3-39.
Table 3-1. Input Assignability of Data Types (page3of3)
Java Wrapper Class Java Primitive Data Type
*
Maps to SQL Data Type...
*
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.