Re: Using SQR3 for batch processing

[Michael Docteroff <doctoroffm@PT.CYANAMID.COM>]

     Marcel,

     I have worked on systems that use SQR for all daily and nightly batch
     processing. Including Material Requirements Planning modules, Accounts
     Payable check processing, Physical Inventory systems and even Accounts
     Payable Check Reconciliation processes that read interfaced files from
     a companies financial institution.

     I think SQR is a real powerful transaction processing tool and would
     be a great choice for what you are trying to accomplish.

     The systems I worked on were running under HP-UX and using an Oracle
     database and the security issues were handled by the operating system
     and the database.

     Now that SQR allows you to write to multiple output files error
     logging has become easier to handle.


     If you have any questions please feel free to contact me at
     609-716-3233.

                                        Michael A.Docteroff
                                        M.A.D. Technologies




______________________________ Reply Separator _________________________________
Subject: Using SQR3 for batch processing
Author:  marcelg@NEW.ISCORLTD.CO.ZA at GATEWAY
Date:    1/14/97 4:39 AM


Because of the power and ease of use of SQR3, we are contemplating using it
for purposes other than reportwriting.

Is anyone else currently using SQR3 in the UNIX environment for other tasks
(e.g. batch jobs)?  These tasks could include database housekeeping and
interfacing to outside systems (e.g. file transfers, etc.)

If you are using SQR3 in this manner, I would like to know how issues like
error logging, security, etc. are handled.

Thank you
Marcel Groenewald