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: "SQLCODE -4700" error when you use Managed Provider for DB2 to run a query against IBM DB2V10 in compatibility mode

FIX: "SQLCODE -4700" error when you use Managed Provider for DB2 to run a query against IBM DB2V10 in compatibility mode

View products that this article applies to.

Symptoms

You run an SQL query against an IBM DB2 V10 Relational Database Management System that's configured for compatibility mode. When you use the Managed Provider for DB2 feature that's included with Microsoft Host Integration Server 2013, you may receive the following error message:

ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE SQLSTATE : 56038 SQLCODE : -4700.

↑ Back to the top

Cause

This problem occurs because Managed Provider for DB2 does not check against different modes. Instead, the provider incorrectly performs a New Function Mode-capable query every time.

↑ Back to the top

Resolution

Cumulative update information

The fix that resolves this problem is included in Cumulative Update 1 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

More Information

Third-party information disclaimer
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

↑ Back to the top

Keywords: kbqfe, kbfix, kbnotautohotfix, kbexpertiseinter, kbbug, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2889355
Revision : 1
Created on : 1/7/2017
Published on : 3/31/2014
Exists online : False
Views : 315