The following table lists the preferred getXXX() method for each
data type.
getXXX() methods called for declared SQL types
This table lists the preferred getXXX() method for each data type.
Column Type Declared by CREATE FUNCTION
getXXX() Method Called by
BIGINT
getLong()
BLOB
getBlob()
CHAR
getString()
CHAR FOR BIT DATA
getBytes()
CLOB
getClob()
DATE
getDate()
DECIMAL
getBigDecimal()
DOUBLE
getDouble()
DOUBLE PRECISION
getDouble()
FLOAT
getDouble()
INTEGER
getInt()
LONG VARCHAR
getString()
LONG VARCHAR FOR BIT DATA
getBytes()
NUMERIC
getBigDecimal()
REAL
getFloat()
SMALLINT
getShort()
TIME
getTime()
TIMESTAMP
getTimestamp()
VARCHAR
getString()
VARCHAR FOR BIT DATA
getBytes()
XML
Not supported