Using ODBC Linked Server to AS400. After upgrading to V7 this query that worked on v5r4 returns"
OLE DB provider "MSDASQL" for linked server "MOPICO" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
OLE DB provider "MSDASQL" for linked server "MOPICO" returned message "[IBM][iSeries Access ODBC Driver]String data right truncation.".
OLE DB provider "MSDASQL" for linked server "MOPICO" returned message "[IBM][iSeries Access ODBC Driver]Column 9: CWB0111 - A buffer passed to a system call is too small to hold return data".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_INDEXES" for OLE DB provider "MSDASQL" for linked server "MOPICO". The provider supports the interface, but returns a failure code when it is used.
SELECT
WEIGHT_TICKET AS WLOAD
,VENDOR AS WVEND
,VNDNAM AS WNAME
,VENDOR_BOL AS WBOL
,SUM(CLITO) AS WQTY
FROM [xxxxx].[dbo].[tblWeightTicket]
JOIN xxxxx.xxxxx.xxxxxx.CUKE004
ON weight_ticket = cload
JOIN xxxxx.xxxxx.xxxxx.AVM
ON CVEND = VENDOR
WHERE MODIFIED_DATE > DATEADD(MONTH,-6,GETDATE())
GROUP BY WEIGHT_TICKET,VENDOR,VNDNAM,VENDOR_BOL
ORDER BY WEIGHT_TICKET
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.