Re: AS400 to PC and Back ??

[John Hall <jhall@xxxxxxxxxxx>]

We use a product called delphi/400.  This uses record level access and
performs down in the .1 sec range  /record on our 170.

Have you tried creating a logical file which would select only the
records which are in error?  It sounds like the package you are using IS
sending the whole file to the PC.  I have run into this problem with
various packages - the actual record selection is done at the PC level
(ODBC has done this to me).  If you cannot create a logical maybe you
can have the Delphi app run an as400 program that extracts the records
and then open that file ?

The largest file we are working with in Delphi 400 is only about 200,000
records but we expect sub-second response time unless the system is
heavily loaded.

John Hall
Home Sales Co.

Vijosh A wrote:
> 
> Hi Folks,
> 
> One of our applications on the AS400  dumps erroneous transactions of the
> day into 4 physical files. There is a PC based application developed in
> Delphi which the finance guys use. Every morning the finance guy logs into
> the Delphi system on his PC.  The Delphi system connects to the AS400
> through DDI/400  (a 3rd party software) and makes the records of these files
> available to the user. The user edits and corrects these transactions. When
> he exits from the Delphi application the transactions go back to the AS400.
> All this is automatic. Later during the day end procedure the corrected ones
> if found okay is taken from these 4 PF's and moved.
> 
> The problem is that it is too slow. The Delphi user has to wait for 45
> minutes before he gets something to edit. All subsequent actions also take
> lot of time.  DDI/400 makes the physical file available to the Delphi system
> through DDM files.
> 
> Can anybody suggest ways of making this process faster?
> 
> We have feeling that FTP may make the whole process faster. But the database
> is too large. So it is not feasible to download the whole database on to the
> PC and send it back to the AS400.
> 
> Vijosh A
> Senior Consultant
> Systems & Software
> SEEPZ, Bombay, INDIA.
> Email : <vijosha@alfuttaim.co.ae>
> 
> +---
> | 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
+---