Here is a solution obtained from an AS400 / iSeries partner of ours, as other AS400/Monarch users have had the same issue. The key issue is to use a driver that will properly convert the data to ASCII. Sounds like the driver you are using brings the data over still in EBCDIC format.
Here is the information:
There are two drivers I have used that work. One is a third party driver
from DataDirect. They driver can be downloaded from here:
The Database/OS levels supported are here:
The other driver is available freely, as far as I know, and is included
with IBM Client Access (Express). It may be available in the full version
of Client Access as well. I'm not sure. If your client doesn't have it, they
should be able to get it here:
[size="1"][ October 13, 2005, 03:03 PM: Message edited by: Mike Urbonas ][/size]
This does not directly address your question/issue but is a possible work around. Down side is that it's not dynamic but rather a static view.
Could you create a AS400 query that would read your table and output a file and then download that file using ASCII/tab delimited.
Just a suggestion.
Getting back to ODBC - are you using Reflections as your emulator? It comes with an ODBC driver that should allow you to connect to AS400 tables directly.
I used that query export approach before. But I am trying to make it dynamic and reduce the number of steps so that I can hand over the process to the users. I want the user to be able to seimply open the report, open the model, and then export.
I am using the Personal Communications that comes with iSeries Access for Windows. Do you think that might be the problem?