RE: AS400 to PC and Back ??

Thanks for your suggestions.

Here erroneous transaction does not mean bad data. It means that the
somebody has to verify and say ok to these transactions so that they can be
posted to finance. Till approval it is logically treated as error (because
the bunch may have wrong entries too)  transactions. During verification he
may correct some amounts. E.g. Suppose you ask for a loan of $1000 from your
company. In that case the company will go through your application and
decide to give you $500. 

 This does not happen to all transaction, but to very specific kind of
transactions. 



Vijosh A 
Senior Consultant
Systems & Software 
SEEPZ, Bombay, INDIA.
Email : <vijosha@alfuttaim.co.ae>


        -----Original Message-----
        From:   Rob Berendt [SMTP:rob@dekko.com]
        Sent:   Monday, December 06, 1999 5:51 PM
        To:     MIDRANGE-L@midrange.com
        Subject:        Re: AS400 to PC and Back ??

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