BUG: Four-part Name Linked Server Queries Fail Against DB2 for OS/390

ID: Q235213

The information in this article applies to:

SYMPTOMS

When you run a four-part name query such as the following

SELECT * FROM LinkedServer name.Catalog.Schema name.Table name
using the Microsoft OLE DB Provider for DB2 from a linked server to DB2 on OS/390, the following error might be reported by the SQL Server:
Server: Msg 7314, Level 16, State 1, Line 1
OLE DB provider 'DB2OLEDB' does not contain table 'Schema name.Table name'.


WORKAROUND

Use pass-through queries with OPENQUERY or OPENROWSET. For examples of linked server queries to DB2 using OPENQUERY or OPENROWSET, please refer to the following article in the Microsoft Knowledge Base:

Q222937 Creating a Linked Server to DB2 using Microsoft OLE DB Provider for DB2


STATUS

Microsoft has confirmed this to be a problem in Microsoft SNA Server version 4.0 Service Pack 2.

Additional query words: Mainframe ODBC MSDB2OLE MVS DB2/400 


Keywords          : 
Version           : WINDOWS:4.0 SP2
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: June 30, 1999