Re: PC Record Level Access to AS/400 via VB

[DAsmussen@xxxxxxx]

Bob,

In a message dated 97-05-09 01:50:43 EDT, you write:

> I jave a friend (Honest!) that is attempting to do record level access
>  from Visual Basic (32 bit Win95) to the AS/400 (V3R6 & V3R7). The
>  performance of SQL was unacceptable as he was joining four files, and it
>  appeared that after the last record for a particular selection criteria
>  was read, the system continued to read all of the records in the file.
>  Since the files are large, response was something like sub-HOUR, but
>  barely!
>  
>  He wants to try old fashioned chains to the individual files, and would
>  like to know if anyone has any experience with any ot the 3rd part API
>  or DLLs available. He has looked at DDA, and it looks interesting, but
>  is a little pricey for what he wants to do.

We use ESS/400 at my current client, with great success (one of the other
consultants liked it so much he became a distributor for it!).  You can visit
them at www.ess400.com.

HTH,

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@AOL.COM

"Experience is something that you have plenty of when you're too old to get
the job." -- Anonymous
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *