Release Notes

6MapDateDescribe CLI/ODBC configuration keyword

6Keyword description:

6Controls the SQL data type returned when DATE columns and parameter 6markers are described.

6db2cli.ini keyword syntax:

6MapDateDescribe = 0 | 1 | 2

6Default setting:

6The default SQL data type for DATE data is returned: SQL_DATE for 6ODBC 2.0 or SQL_TYPE_DATE for ODBC 3.0.

6Usage notes:

6  6

6To control the SQL data type that is returned when DATE columns and 6parameter markers are described, set MapDateDescribe as follows: 6

• 60 - to return the default SQL data type: SQL_DATE for ODBC 62.0 or SQL_TYPE_DATE for ODBC 3.0
• 61 - to return the SQL_CHAR SQL data type
• 62 - to return the SQL_WCHAR SQL data type 6

6Only the following DB2 CLI functions are affected by setting 6MapDateDescribe: 6

• 6SQLDescribeCol()
• 6SQLDescribeParam()
• 6SQLGetDescField()
• 6SQLGetDescRec() 6

6The DB2 CLI catalog functions are not affected by this 6keyword.