Home | Previous Page | Next Page   Data Types > Reporting Standard ODBC Types >

DSN Settings for Report Standard ODBC Data Types

UNIX Only

Add a new DSN option "NeedODBCTypesOnly" under your DSN setting in your .odbc.ini file [default is 0]. For example:

[Informix9]
Driver=/informix/lib/cli/libthcli.so
Description=Informix ODBC 3.81 Driver
....
NeedODBCTypesOnly=1
End of UNIX Only
Windows Only

Check this option under the Advanced tab of the ODBC Administration for IBM Informix Driver DSN [default is 0].

End of Windows Only

The following table shows how the INFORMIX 9 data types map to the standard ODBC data types. These types are in addition to the Informix data types.

INFORMIX 9
ODBC
Blob
SQL_LONGVARBINARY
Boolean
SQL_BIT
Clob
SQL_LONGVARCHAR
Int8
SQL_BIGINT
Lvarchar
SQL_VARCHAR
Serial8
SQL_BIGINT
Multiset
SQL_C_CHAR/SQL_C_BINARY
Set
SQL_C_CHAR/SQL_C_BINARY
List
SQL_C_CHAR/SQL_C_BINARY
Row
SQL_C_CHAR/SQL_C_BINARY
Important:
For multiset, set, row, and list data types, the data type is mapped to the defaultUDTFetchType attribute set (SQL_C_CHAR or SQL_C_BINARY).
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]