BigintDefaultCMapping IBM data server driver configuration keyword

Specifies the default C type of BIGINT columns and parameter markers.

Equivalent CLI keyword
MapBigintCDefault
Equivalent IBM® Data Server Provider for .NET connection string keyword
N/A
db2dsdriver.cfg configuration syntax
<parameter name="BigintDefaultCMapping" value="0 | 1 | 2"/>
Default setting:
0
Usage notes:
BigintDefaultCMapping controls the C type that is used when SQL_C_DEFAULT is specified for BIGINT columns and parameter markers. Use this keyword primarily with Microsoft applications, such as Microsoft Access, which cannot handle 8-byte integers. Set BigintDefaultCMapping as follows:
  • 0 - for the default SQL_C_BIGINT C type representation
  • 1 - for an SQL_C_CHAR C type representation
  • 2 - for an SQL_C_WCHAR C type representation
This keyword affects the behavior of CLI functions where SQL_C_DEFAULT might be specified as a C type, such as SQLBindParameter(), SQLBindCol(), and SQLGetData()