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 number
IT30675
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-10-23
Closed date
2021-03-31
Last modified date
2021-03-31
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
[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"11.1"}]
Document Information
Modified date:
04 May 2022