Solved

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

Posted on 2010-11-24
6
2,692 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
ID: 34207408
SQL Server
0
 
LVL 45

Accepted Solution

by:
aikimark earned 500 total points
ID: 34212330
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
ID: 34312779
Waiting on a solution that does not require using MS DB2OLEDB connector...
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 45

Expert Comment

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

Author Comment

by:RLKNOX
ID: 34314525
thanks.
0
 
LVL 45

Expert Comment

by:aikimark
ID: 34326822
@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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Details to create developer account 10 34
SSIS with VPN COnnection 2 70
VB.net and sql server 4 33
Deal with apostrophe in stored procedures 8 40
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

816 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

9 Experts available now in Live!

Get 1:1 Help Now