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.

FIX: OLE DB provider for DB2 fails and returns VALNSPRM if stored procedure name is longer than 18 characters


View products that this article applies to.

Symptoms

You call a stored procedure at the mainframe by using the OLE DB provider for DB2.

If the name of the stored procedure is longer than 18 characters, the full result set is not returned. Instead, you may see the following DDM reply message (VALNSPRM) when you run DB2 network library traces:
SQLSTATE: HY000, SQLCODE: -385  Message : An internal network library error has occurred. The requested command included a parameter value that is not recognized or is not supported by the target system.

↑ Back to the top


Resolution

The fix that resolves this problem is included in the following cumulative updates for Host Integration Server:

Cumulative Update 2 for Host Integration Server 2016

Cumulative Update 4 for Host Integration Server 2013

↑ 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


References

Learn about the terminology Microsoft uses to describe software updates.

↑ Back to the top


Keywords: kbQFE, kbfix, kbBug, kbExpertiseInter, kbsurveynew

↑ Back to the top

Article Info
Article ID : 3141607
Revision : 9
Created on : 10/27/2017
Published on : 11/24/2017
Exists online : False
Views : 284