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

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".
RLKNOXAsked:
Who is Participating?
 
aikimarkConnect With a Mentor Commented:
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
 
RLKNOXAuthor Commented:
SQL Server
0
 
RLKNOXAuthor Commented:
Waiting on a solution that does not require using MS DB2OLEDB connector...
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
aikimarkCommented:
I recommend you click the Request Attention link and ask for some more expert visibility on this question.
0
 
RLKNOXAuthor Commented:
thanks.
0
 
aikimarkCommented:
@RLKNOX

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

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.