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

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.

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

Status

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

References

Learn about the terminology Microsoft uses to describe software updates.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

×