IT28771: SQLGETTYPEINFO WITH SQL_BOOLEAN IS NOT RETURNING ANY RESULT

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 is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IT31167

Fix information

• Fixed component name

  DB2 CONNECT

• Fixed component ID

  DB2CONNCT

Applicable component levels

• RB10 PSN

     UP