The data type conversions used by the input values of Java Scalar UDFs and Java Table UDFs.
SQL type | Java Type |
---|---|
BIGINT | long |
BINARY | byte[ ] |
BIT | boolean |
CHAR | String |
DATE | java.sql.Date |
DECIMAL | java.math.BigDecimal |
DOUBLE | double |
IMAGE | byte[ ] |
INTEGER | int |
LONG BINARY | byte[ ] Note: Large object data support requires a
separately licensed SAP Sybase IQ
option.
|
LONG VARCHAR | String Note: Large object data support requires a
separately licensed SAP Sybase IQ
option.
|
MONEY | java.math.BigDecimal |
NUMERIC | java.math.BigDecimal |
REAL | float |
SMALLINT | short |
SMALLMONEY | java.math.BigDecimal |
TEXT | String |
TIME | java.sql.Time |
TIMESTAMP | java.sql.Timestamp |
TINYINT | byte |
UNSIGNED BIGINT | java.math.BigDecimal (with a precision of 20 and scale of 0) |
UNSIGNED INT | java long |
VARBINARY | byte[ ] |
VARCHAR | String |