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 thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.