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


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
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
If the trigger isn't designed to return errors, then I might guess at
an authority or library list problem.
From: bill.blalock@xxxxxxxx

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

The called RPGLE program runs in the job QZRCSRVS

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

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

An error in the trigger program was detected before WRITE on file
Function check. RNX1023 unmonitored by CKBIL1RG at statement
instruction X'0000'.
An error in the trigger program was detected before WRITE on file
(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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.