Preferred <i>getXXX()</i> methods for <ph conref="../conrefs.dita#prod/productshortname"></ph>-style table functions While scanning a -style table function, calls a preferred getXXX() method for each column, based on the column's data type. Functionstable function getXXX() methods

The following table lists the preferred getXXX() method for each data type.

<i>getXXX()</i> methods called for declared SQL typesThis 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