RE: Trigger error

[Cesar Altamirano <cesaralt@xxxxxxxxxx>]

Hi,
Is it possible to get the Object Caller (or program) that originated the
updating of the file to retireved it in the program that control the trigger.

Regards,
Cesar A.

At 02:34 p.m. 25/11/03, you wrote:
> Ok, this is what happened.  A programmer has ran ADDPFTRG on the database
> in question.  In their program they used the api to send an escape
> message.  The id of the escape message they sent was CPF9898 which is one
> of two or three generic id's that IBM has in QCPFMSG.  The text they
> supplied on the message was rather crude 'Trigger error.'  Knee them in
> the groin.
> You should be able to do a DSPFD FILE(...) TYPE(*TRG) on that file to look
> for the trigger information.  Then you can delve into that code and see
> what conditions would generate that error.
>
> Rob Berendt
> --
> "They that can give up essential liberty to obtain a little temporary
> safety deserve neither liberty nor safety."
> Benjamin Franklin
>
>
>
>
> "Willie J. Moore" <WJMoore@xxxxxxxxxxxxxxx>
> Sent by: rpg400-l-bounces+rob=dekko.com@xxxxxxxxxxxx
> 11/25/2003 02:06 PM
> Please respond to
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
>
>
> To
> "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
> cc
>
> Fax to
>
> Subject
> RE: Trigger error
>
>
>
>
>
>
> I did display the job log.  Here is what it shows:
> Error found on CALL command.
> Trigger error.
> Function check. CPF9898 unmonitored by OPNAR at statement  .DRVRU01,
> instruction X'00FD'
> Willie..
>
> -----Original Message-----
> From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
> Sent: Tuesday, November 25, 2003 10:22 AM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: Trigger error
>
>
> Display the joblog.  The trigger program probably sent an escape message
> to it.
>
> Keep us posted...
>
> Rob Berendt
> --
> "They that can give up essential liberty to obtain a little temporary
> safety deserve neither liberty nor safety."
> Benjamin Franklin
>
>
>
>
> "Willie J. Moore" <WJMoore@xxxxxxxxxxxxxxx>
> Sent by: rpg400-l-bounces@xxxxxxxxxxxx
> 11/25/2003 01:00 PM
> Please respond to
> RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
>
>
> To
> <rpg400-l@xxxxxxxxxxxx>
> cc
>
> Fax to
>
> Subject
> Trigger error
>
>
>
>
>
>
> I am trying to update the Customer PO field in the OPENAR file with
> Customer PO data from another file.  When I try this, I get the following
> message: RPG9998 Internal failure in compiler or subroutine.  I took the
> 'D' option and looked at the dump.  Under 'Message Data' is showed
> 'Trigger error'.
> I am hopping someone can give me ideals on how to correct this.
> Thanks in advance,
> William Moore
>
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.