The extensions for opaque types

The extensions for processing opaque types allow your application to specify the return type to which the database server should cast the opaque type before returning it to the client. This is known as prebinding the return value. The methods are:

• setBindColType(), which allows applications to specify the output type of result-set values using standard JDBC data types from java.sql.Types
• setBindColIfxType(), which allows applications to specify the output type of result-set values using HCL OneDB™ data types from com.informix.lang.IfxTypes

  For more information about the available types, see The IfxTypes class.

• clearBindColType(), which resets values set through the previous two methods

In the following topics:

• The colIndex parameter specifies the column: 1 is the first column, 2 the second, and so forth
• The sqltype parameter is a value from java.sql.Types: for example, Types.INTEGER.
• The ifxtype parameter is a value from IfxTypes: for example, IfxTypes.IFX_TYPE_DECIMAL.