RE: Problem with a data base trigger not working when programiscalled from Java

Joe:

The errors were cut and paste from the job log of QZRCSRVS. I'll recheck
lib list and authorities. Adding the error checking / reporting within
the program is a good idea.

This program has been running for a couple of years without problem. Now
a trigger was placed on the data base file that the program writes. You
are right, the program may have to be retrofitted with better error
reporting.

Thanks!





Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>
10/10/2007 12:07 PM
Please respond to Java Programming on and around the iSeries / AS400

To: Java Programming on and around the iSeries / AS400
<java400-l@xxxxxxxxxxxx>
cc: (bcc: Bill Blalock/TUS/US/Certegy)
Subject: RE: Problem with a data base trigger not working
when programiscalled from Java


What is the actual error that the trigger program is reporting? RNX1023
simplly says an error occurred. The joblog should give you more
information.
If the trigger isn't designed to return errors, then I might guess at
either
an authority or library list problem.
Joe

From: bill.blalock@xxxxxxxx

I have Java program running on a server is calling a System i RPGLE
program with

com.ibm.as400.data.ProgramCallDocument.callProgram()

The called RPGLE program runs in the job QZRCSRVS

A trigger was added to the data base file the called PRGLE program

writes.

The called RPGLE program is now failing. The messages are:

An error in the trigger program was detected before WRITE on file
CKIBLC01.
Function check. RNX1023 unmonitored by CKBIL1RG at statement
0000005500,
instruction X'0000'.
An error in the trigger program was detected before WRITE on file
CKIBLC01
(C G D F).

The called RPGLE program works fine in a "normal" environment. The
trigger fires when the data base record is changed, etc.