Re: AS400 to PC and Back ??

[Rob Berendt <rob@xxxxxxxxx>]

Why not fix the program on the 400 to stop putting erroneous transactions into 
the files?
Second option, write a green screen program for the guy to fix the transactions.
Third option, if you can isolate what these changes are that the guy makes then 
can you write 
a batch program that runs after the first one screwed up the data.  The fix 
batch would do the 
work for him.

Be careful what the guy calls erroneous data.  Many moons ago when I worked for 
a consultant 
we had a client that wanted us to omit one customer from their aged accounts 
receivable printout.  
Looked bad when they took it to the bank.  We discussed it with our superior 
and there was some 
plausable explanation at the time for doing so.





VijoshA@alfuttaim.co.ae on 12/04/99 08:23:15 AM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        AS400 to PC and Back ??

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
+---