Re: Using SQR3 for batch processing

[Marcel Groenewald <marcelg@NEW.ISCORLTD.CO.ZA>]

Thank you for your reply.

I work for a large steel manufacturing company on exactly the same platform
you are (i.e. Oracle on HPUX).  I would appreciate it if you could tell me
how you handle certain issues:

1.  How does your SQR programs log on to the database?  Is the username and
password hard coded in your programs? If so, what do you do when a password
changes? Don't you see this as a possible security problem (i.e. anyone
with access to your program can get a database login) ?

2.  Are your SQR systems 24x7 type of systems?  If so, what do you do when
an error occurs?  We have 24 hr operations people who could monitor for
errors or resource usage, but I'm just wondering what will be the best way
to do this (e.g. using some systems management tool like HP/Openview).
How are your systems handling this?  Can your systems notify a user when an
error occured?

3.  Do you keep logs of execution times? (i.e. when last a certain program
executed)

4.  Do you have any architecture for kicking of your batches from a client
PC running Windows?  (I.e. a client wants to run a certain SQR program on
the HPUX server, and not on his PC.  He may want to be notified when it
completed and view the results, log, etc.)

5.  How many people in your environment are coding using SQR3?  Do you have
some coding standards or guidelines? (e.g. the general layout of the
program, how to handle errors, what to log where and when, etc.)

Thank you for your interest

Marcel Groenewald

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