APAR status
Closed as program error.
Error 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.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * CLI/ODBC users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 11.1.4.5 * ****************************************************************
Problem conclusion
With the fix customer can get the details about BOOLEAN data type using SQLGetTypeInfo.
Temporary fix
Comments
APAR Information
APAR number
IT28771
Reported component name
DB2 CONNECT
Reported component ID
DB2CONNCT
Reported release
B10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-04-12
Closed date
2020-02-23
Last modified date
2020-02-23
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 CONNECT
Fixed component ID
DB2CONNCT
Applicable component levels
RB10 PSN
UP
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"11.1"}]
Document Information
Modified date:
02 September 2021