Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Khalil Shaddad
  Where is Khalil Shaddad?
 Beirut
 Lebanon
 Khalil Shaddad
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: Client Access from IBM.
Thread ID: 16129 Message ID: 16204 # Views: 3 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Friday, October 11, 2002 12:50:38 PM         
   


> > I have to read information from an AS400.
> > I understand how to use "create remote view" and I know there are some othere options. My question is what is the best and fastest way to get data from a platform like this.
> > These will be large tables and I will be searching through them .
> > I dont need detailed instructions, just looking for concepts right now.
>
> Hi,
> Nobody has answered you and I think that there are probably not a lot of us
> familar with the AS400. I do not know if it is ADO compliant. ODBC may not
> be the fastest way, but when reading the documentation it maybe the only way.
> Basically ODBC as you know requires a remote view and is a lot slower than
> other means to access the date. You comment on the fastest way to get data,
> if you are looking at a one time shot say in a data-port, ODBC will do. But
> if you are looking at accessing, reading and writing on an ongoing bases look
> on the MS web site under ADO and see if the AS400 supports it.
>
> Pete from the Great White North ! (Only in Canada, ay...) Over and Out ...

Hi,
As to my knowledge IBM provides (upon AS400 purchasing) a software called Client Access which has to be installed on the client PC and well configured in order for you to be able to connect to AS400 server.
Regarding speed, it depends on table(s) size, number of tables openned in one view, etc... for example, a select SQL based on a table of 150 000 records will take seconds.
In any case search on IBM web-site for "Client Access" and probably you will find something relevent.
Khalil Shaddad (Lebanon)

ENTIRE THREAD

Using ODBC Posted by Shawn Ottinger @ 10/9/2002 8:51:59 PM
RE: Using ODBC Posted by Pete Sass @ 10/11/2002 11:18:36 AM
Client Access from IBM. Posted by Khalil Shaddad @ 10/11/2002 12:50:38 PM
RE: Client Access from IBM. Posted by Neil Fairbanks @ 10/11/2002 4:30:25 PM