[thelist] DB2/400 returns EBCDIC

[Christopher Joseph]

Unfortunately ODBC is considered very slow from NT to iSeries. I think in
testing we concluded that it was a ratio of 6:1  ODBC to OLEDB. Some
thoughts:

You might consider setting up WAS on the iSeries and passing the request?

You could use native DB2/400 connectivity (I think it is called DB2 Connect)

Sorry I couldn`t be more help.

Chris.

P.S you could try asking
http://www.webspherepro.com/wpforums/Main.cfm?CFApp=72
OR http://www.ignite400.org



-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of
Ron_Senykoff at beaerospace.com
Sent: Monday, April 29, 2002 8:52 AM
To: thelist at lists.evolt.org
Subject: RE: [thelist] DB2/400 returns EBCDIC



<snip>
Sorry didn`t see this till now. Quick question? Is your WAS running on the
iSeries machine? If it is the iSeries should be able to translate the
ebcdic
to ascii happily with the right map directive on the http server.

a little like this :

Exec /cgifram/* /QSYS.LIB/cgi_fram.LIB/*  %%EBCDIC%%

chris.
</snip>

WAS is running on NT.  Wish I could find a solution as simple as your
iSeries answer!
For now I'm stuck using the JD Edwards ODBC driver, but I know there's got
to be a better solution.  I mean, isn't ODBC considered sort of a
last-resort route?

-Ron

--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !