|
Problem IT28771
|
Status: Closed |
SQLGETTYPEINFO WITH SQL_BOOLEAN IS NOT RETURNING ANY RESULT
|
| product: |
DB2 CONNECT / DB2CONNCT / B10 - DB2 |
| Problem description: |
BOOLEAN datatype is supported from db2 v11.1, but sqlgettypeinfo
is not working
> > > sqlallochandle SQL_HANDLE_ENV SQL_NULL_HANDLE 1
SQLAllocHandle: rc = 0 (SQL_SUCCESS)
CLI handle = 1, Test Driver handle = 1
> sqlallochandle SQL_HANDLE_DBC 1 1
SQLAllocHandle: rc = 0 (SQL_SUCCESS)
CLI handle = 1, Test Driver handle = 1
> sqlconnect 1 test2 -3 db2admin -3 passwd -3
SQLConnect: rc = 0 (SQL_SUCCESS)
> SQLAllocStmt 1 1
SQLAllocStmt: rc = 0 (SQL_SUCCESS)
CLI hstmt = 1, Test Driver hstmt = 1
> SQLAllocStmt 1 2
SQLAllocStmt: rc = 0 (SQL_SUCCESS)
CLI hstmt = 2, Test Driver hstmt = 2
> SQLGetTypeInfo 1 SQL_BOOLEAN
SQLGetTypeInfo: rc = 0 (SQL_SUCCESS)
> fetchall 1
FetchAll: 0 rows fetched.
> sqlfreestmt 1 SQL_CLOSE
SQLFreeStmt: rc = 0 (SQL_SUCCESS)
> sqldisconnect 1SQLDisconnect: rc = 0 (SQL_SUCCESS)
>
SQLGetTypeInfo with SQL_BIT SQL_ALL_TYPES also are not
returning about BOOLEAN data type. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* CLI/ODBC users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 11.1.4.5 *
**************************************************************** |
| Local Fix: |
N/A |
| Solution |
|
| Workaround |
not known / see Local fix |
| BUG-Tracking |
forerunner :
follow-up : IT31167 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.04.2019
23.02.2020
23.02.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
