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
midrange.com
