Hi everybody,
a very strange error comes up on OS/400 V5R1M0 when using SQL Triggers.

With a specific combination of CL commands and then a call to an RPG
program, OS/400 pops-up CPF4293 error;
description for the message refers to a "Commitment control" problem but,
actually, no STRCMTCLT command is issued and consequently no COMMIT or
ROLLBACK are issued as well ....

After many tests, I reached the core of the problem by replacing the SQL
trigger with a "normal" RPG trigger and no CPF raised up by executing my
program(s).

Did anyone ran into the same problem ?

If there is someone interested with this matter, I can provide the sources
to replicate my tests and the error; if I'm not wrong, V5R1 is a "must" for
SQL triggers ...


Thanks for your attention

Fabio Gloria






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-2021 by midrange.com 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.