Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Neil Fairbanks
  Where is Neil Fairbanks?
 Wisconsin - United States
 Neil Fairbanks
 To: Khalil Shaddad
  Where is Khalil Shaddad?
 Khalil Shaddad
Subject: RE: Client Access from IBM.
Thread ID: 16129 Message ID: 16207 # Views: 2 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Friday, October 11, 2002 4:30:25 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)

Hi Shawn,

Both suggestions from Pete and Khalil may work for your situation, it depends on what you need to do and if you need to update the AS400 data. It's been a couple of years since I have worked with an AS400 but I will share a method that I had used: What we had was a database on a PC network that extracted AS400 data and updated the PC network database. We used the AS400 data as master tables and then extrapolated the information and reports that we wanted to work with. I believe that Client Access supports downloads and data conversions. I used an old System/36 routine to extract the AS400 data and convert it to PC format (I don't remember what it was called though).



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