JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

Table 12 System Functions
SQL/MX Equivalent FunctionJDBC Function
CURRENT_USERCURRENT_USER
SYSTEM_USERSYSTEM_USER
USERUSER
CONVERT Function
JDBC/MX uses the SQL/MX CAST function to support the JDBC CONVERT function. The JDBC
CONVERT function has the following format:
{ fn CONVERT( value_exp, data_type ) }
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:
SQL/MX Data TypeSupported by JDBC/MXJDBC Data Type
NoTypes.Array
LARGEINTYesTypes.BIGINT
NoTypes.BINARY
NoTypes.BIT
YesTypes.BLOB
CHAR(n)YesTypes.CHAR
YesTypes.CLOB
DATEYesTypes.DATE
DECIMAL(p,s)YesTypes.DECIMAL
NoTypes.DISTINCT
DOUBLE PRECISIONYesTypes.DOUBLE (*)
FLOAT(p)YesTypes.FLOAT (*)
INTEGERYesTypes.INTEGER
NoTypes.JAVA_OBJECT
NoTypes.LONGVARBINARY
VARCHAR[(n)]Yes**Types.LONGVARCHAR
NoTypes.NULL
NUMERIC(p,s)YesTypes.NUMERIC
FLOAT(p)YesTypes.REAL
SQL Conformance 71