JDBC Driver for SQL/MX Programmer's Reference

The SQL/MX CAST has this format:
CAST( { value_exp | NULL } AS data_type )
SQL/MX translates the CONVERT syntax to the CAST syntax, converting the data type argument to its equivalent SQL/MX value. For
example, if the JDBC data type parameter for character data is an integer value (SQL_CHAR or 1), the equivalent SQL/MX data type is a
string literal with a value of CHARACTER.
JDBC Data Types
The following table shows the JDBC data types that are supported by JDBC/MX and their corresponding SQL/MX data types:
JDBC Data Type
Supported
by
JDBC/MX
SQL/MX Data
Type
Types.Array
No
Types.BIGINT
Yes
LARGEINT
Types.BINARY
No
Types.BIT
No
Types.BLOB
Yes
Types.CHAR
Yes
CHAR(n)
Types.CLOB
Yes
Types.DATE
Yes
DATE
Types.DECIMAL
Yes
DECIMAL(p,s)
Types.DISTINCT
No
Types.DOUBLE
(*)
Yes
DOUBLE
PRECISION
Types.FLOAT
(*)
Yes
FLOAT(p)
Types.INTEGER
Yes
INTEGER
Types.JAVA_OBJECT
No
Types.LONGVARBINARY
No
Types.LONGVARCHAR
Yes**
VARCHAR[(n)]
Types.NULL
No
Types.NUMERIC
Yes
NUMERIC(p,s)
Types.REAL
Yes
FLOAT(p)
Types.REF
No
Types.SMALLINT
Yes
SMALLINT
Types.STRUCT
No
Types.TIME
Yes
TIME
Types.TIMESTAMP
Yes
TIMESTAMP
Types.TINYINT
No
Types.VARBINARY
No