IT30675: DB2 CLI/ODBC FAILING WHEN INSERTING THE NULL VALUE TO BOOLEAN DATA TYPE USING PARAMETER MARKER

APAR status

• Closed as program error.

Error description

• When doing the array insert on a SQL statement which has boolean
  column, when one of the boolean column is supplied with
  SQL_NULL_DATA, CLI is returning
  [IBM][CLI Driver] CLI0164E  Nullable type out of range.
  SQLSTATE=HY099
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * DB2 CLI users using boolean column                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 version 11.1.4.6                              *
  ****************************************************************
  

Problem conclusion

• DB2 v11.1 M4FP6 contains the fix
  

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:

Fix information

• Fixed component name

  DB2 CONNECT

• Fixed component ID

  DB2CONNCT

Applicable component levels

• RB10 PSY

     UP