SQL/MX Programming Manual for Java

SQLJ Programming
HP NonStop SQL/MX Programming Manual for Java—523726-003
3-33
Input Assignability
java.lang.Byte
java.lang.String
byte 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
java.sql.Date DATE, TIMESTAMP
CHAR[ACTER],
CHAR[ACTER] VARYING,
VARCHAR, PIC[TURE] X,
NATIONAL CHAR[ACTER],
NATIONAL CHAR[ACTER]
VARYING, NCHAR, NCHAR
VARYING
java.sql.Time TIME, TIMESTAMP
CHAR[ACTER],
CHAR[ACTER] VARYING,
VARCHAR, PIC[TURE] X,
NATIONAL CHAR[ACTER],
NATIONAL CHAR[ACTER]
VARYING, NCHAR, NCHAR
VARYING
java.sql.Timestamp DATE, TIMESTAMP
CHAR[ACTER],
CHAR[ACTER] VARYING,
VARCHAR, PIC[TURE] X,
NATIONAL CHAR[ACTER],
NATIONAL CHAR[ACTER]
VARYING, NCHAR, NCHAR
VARYING
Table 3-1. Input Assignability of Data Types (page2of3)
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.