Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. FIX: ADO.NET provider for DB2 doesn't process static SQL INSERT statement with NULL parameter values against DB2 for LUW

FIX: ADO.NET provider for DB2 doesn't process static SQL INSERT statement with NULL parameter values against DB2 for LUW

View products that this article applies to.

Symptoms

ADO.NET provider for DB2 doesn't process static SQL INSERT statement with NULL parameter values against DB2 for LUW (Linux, UNIX, Windows). Additionally, it returns the following error:

SQLSTATE 07002, SQLCODE -309 

The value of a host variable in the OPEN statement is NULL, but its corresponding use cannot be NULL.

↑ Back to the top

Cause

ADO.NET provider for DB2 doesn't encode NULL values correctly when processing static SQL INSERT statements against DB2 for LUW.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. 

↑ Back to the top

Resolution

This issue is fixed in the following cumulative update for Host Integration Server:

↑ Back to the top

References

Learn about the terminology that Microsoft uses to describe software updates.

↑ Back to the top

Keywords: CI121759, kbHotfixAuto, kbqfe, kbfix, kb, ADO.NET provider for DB2 does not encode NULL values

↑ Back to the top

Article Info
Article ID : 4494467
Revision : 7
Created on : 8/24/2020
Published on : 8/24/2020
Exists online : False
Views : 181