RE: data transfer: AS400 - Windows NT

Marco
        We too have been less impressed with ODBC performance. As it
turns out though, CA/400 has functionality call Optimized SQL. Our
experiences with Optimized SQL have fill the performance gap of ODBC.
Optimized SQL is provided within cwbOBJ.dll.

        We at CMI have written a set of ActiveX objects based upon
cwbOBJ.dll to make the function calls easier to manage. If you are
interested in more information check out http://www.cm-inc.com/AS400ole/

        Many CMI solutions have been built upon AS/400 and NT platforms.
If you need more help or definitions please email me directly at
ken@cm-inc.com and I can provide 'real-world' examples.

Ken Slaugh
(707) 795-1512 Ext 118
Programmer/System Analyst
Certified Network Administrator MSE
Specialist - Client Access/400

Chouinard & Myhre, Inc.
An IBM Premier Business Partner
P.O. Box 636
Cotati, Ca 94931
http://www.cm-inc.com/



-----Original Message-----
From: Marco_Bottaro@carrefour.com [mailto:Marco_Bottaro@carrefour.com]
Sent: Thursday, November 25, 1999 7:39 AM
To: MIDRANGE-L@midrange.com
Subject: data transfer: AS400 - Windows NT


Listers,

I am trying to set up a reliable link between the company as400 server
database
and Access on Windows NT with very limited success. I am using Client
Access to
comunicate between the two systems.

Direct ODBC seems impossible, because of the lack of support on our
as400-sql
for file members. Upgrading the system is not an option (costs).
The Data Transfer program looked like an alternative, but provides
unreliable
results; when I compared the transferred text file with the original
table on
the as400, some fields contained underscores whereas there should be
simple
numbers such as '101' or '103'.

Does anybody have experience with querying an as400 system from a
windows
machine without any need to reprogram the as400? I would like to stress
this
last point, because there is no expertise in house for this.

Thanks in advance.

Marco Bottaro


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---