IBM Support

IT28771: SQLGETTYPEINFO WITH SQL_BOOLEAN IS NOT RETURNING ANY RESULT

Subscribe

You can track all active APARs for this component.

 

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:

    IT31167

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