Solved

Receiving METADATA error when updating AS400 using IBMDASQL from MS SQL SERVER 2008 R2

Posted on 2010-11-24
6
2,632 Views
Last Modified: 2013-12-06
I am getting the following error message when I use the following TSQL statement to update a field on our AS400 (iSeries) table using a SQL Linked Server.  I am using SQL Server 2008 R2 with the IBM OLE DB provider IBMDASQL.  I can issue a command to update the AS400 table with a simple command setting one field back to itself and I do not receive any error messages.  The problem seems to be in one of the settings or with the provider in general when joining the SQL table.  I have provider options “Nested queries”, “Allow inprocess” and “Disallow adhoc access” checked on.  I have linked server options “Data Access”,  “Use Remote Collation” and “Enable Promotion of Distributed Transactions” checked on.  

Anyone have any suggestions?

Statement:

update SQLSERVER_TO_AS400.S105XMWM.LOANS.K667BL45
set CPYMT  = b.loanrec_CPYMT
from SQLSERVER_TO_AS400.S105XMWM.LOANS.K667BL45 a
inner join tblas400tables b
on a.CLOAN = b.loanrec_CLOAN
where logid = 7485

Error message:

The OLE DB provider "IBMDASQL" for linked server "SQLSERVER_TO_AS400" supplied inconsistent metadata. The object "(user generated expression)" was missing the expected column "Bmk1000".
0
Comment
Question by:RLKNOX
  • 3
  • 3
6 Comments
 

Author Comment

by:RLKNOX
Comment Utility
SQL Server
0
 
LVL 45

Accepted Solution

by:
aikimark earned 500 total points
Comment Utility
Please take a look at this IBM bulletin, "SQL Server Restrictions That Affect the Use of IBMDASQL" and evaluate whether these restrictions apply to your environment

http://www-01.ibm.com/support/docview.wss?uid=nas13405e887099cc85f86257315005f23dc
0
 

Author Comment

by:RLKNOX
Comment Utility
Waiting on a solution that does not require using MS DB2OLEDB connector...
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 45

Expert Comment

by:aikimark
Comment Utility
I recommend you click the Request Attention link and ask for some more expert visibility on this question.
0
 

Author Comment

by:RLKNOX
Comment Utility
thanks.
0
 
LVL 45

Expert Comment

by:aikimark
Comment Utility
@RLKNOX

Did you mean to close this question?  I thought you were going to ask for more expert eyes on this thread.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now