AS/400 SQL Triggers giving CPF4293

[fabio.gloria@xxxxxxxxxxxxxx]

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