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



We are periodically transferring some i5/OS DB2 data to SQL Server, but
some files cannot be queried. We installed iSeries Access on a SQL
Server 2005 box, following this article (PDF):
http://www.mcpressonline.com/index2.php?option=com_content&do_pdf=1&id=1
541. We are using linked servers back to DB2.



Most files can be queried and copied using the syntax: select * from
db2400.S11111EC.MYLIB.MYFILE. (This means linked server name . system
name . schema (library) name . table (file) name.)



However, when querying some files, we get the error:

Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current command. The results, if any,
should be discarded.

Msg 0, Level 20, State 0, Line 0

A severe error occurred on the current command. The results, if any,
should be discarded.





I can run a query with the exec at syntax:

Exec('select * from MYLIB.MYFILE') at db2400



But a data transfer never completes.

Insert into somefile exec('select * from MYLIB.MYFILE') at db2400





I've reviewed the files in question, but have not found any significant
differences. All the files are vendor-supplied, DDS, defined with CCSID
37 (EN-US). All of the queries are run from Management Studio's query
window, and will become stored procedures.



I saw two unrelated posts in the archives, and Google isn't my friend
today (nothing jumps out at me).



TIA,

Loyd



--

Loyd Goodbar

Business Systems

BorgWarner Shared Services

662-473-5713




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.