Re: Update Process Monitor Status to 'Error'

[Anne-Marie Matula <amatula@OIT.UMASS.EDU>]

Hi Zubin,

You need to update PSPRCSRQST table, RUNSTATUS field
The error status code = 3.

I have my own on-error procedure that does this.  The same procedure is used
for client and server execution.

The SQR in Peoplesoft book has an *excellent* section on this topic.  Check
this book out at
http://www.amazon.com/exec/obidos/ASIN/1884777775/qid%3D945093871/002-185920
8-3141013

Hope that helps!
Anne-Marie

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Anne-Marie Matula
Student Information System Project
Office of Information Technologies
Whitmore Bldg, University of Massachusetts, Amherst
Phone:  413/577-0685
Fax:    413/545-2150


> Date:    Sat, 11 Dec 1999 14:53:36 -0600
> From:    Zubin Shroff <zshroff@DTTUS.COM>
> Subject: Update Process Monitor Status to 'Error'
>
>      Hi all,
>
>      This relates to running SQRs on a Win 95 client against
> PeopleSoft 7.5
>      on DB2/400.
>
>      When running my SQRs on the client, if an error occurs that
> causes the
>      SQR to abort, the process monitor continues to show 'Processing' or
>      'Initiated'. How can I update this status to 'Error' from within my
>      program?
>
>      Thanks.