×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I just tried the following through a linked server
DELETE FROM [I5].[DAVIS].[GPLIB].[DLAVAIL]
WHERE AVINDEX = 1
GO
And it worked fine. I have SQL Server 2012 and i7.1. So it is possible with those versions. Are you trying this from within SQL Server Management Studio? Maybe try hard coding the value you are trying to delete for testing.
Scott
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Graves, Chuck
Sent: Wednesday, December 03, 2014 3:01 PM
To: midrange-l@xxxxxxxxxxxx
Subject: . iSeries & MSSQL Server (MORE INFO)
Buck,
I actually do get an SQL Server error:
Msg 7352, Level 16, State 1, Procedure BME_Batch_Upload2, Line 98 The OLE DB provider "IBMDASQL" for linked server "LS_ISERIES" supplied inconsistent metadata. The object "(user generated expression)" was missing the expected column "Bmk1000".
When I track this error down, it says that the DB Provider IBMDASQL cannot perform the delete (i.e. it's not capable) I've tried other providers, different ODBC data sources and......hours & hours of dinking around. I have to believe that someone has done this by now... FYI I am on V5R4, with current PTF's
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
