Did you create your program with commit(*none)? The default if you have not changed it is COMMIT(*CHG). CRTSQLRPGI OBJ(PGMNAME) COMMIT(*NONE) Stan Schapeler Consultant Sanden International (USA) Inc. sschapeler@xxxxxxxxxx fabio.gloria@xxxxxxxxxxxxxx Sent by: To: consult400@xxxxxxxxxxxx consult400-bounces+stan.schapeler=sanden.com@mi cc: drange.com Subject: [Consult400] AS/400 SQL Triggers giving CPF4293 12/04/2003 01:25 PM Please respond to Consulting on the iSeries / AS400 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 _______________________________________________ This is the Consulting on the iSeries / AS400 (Consult400) mailing list To post a message email: Consult400@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/consult400 or email: Consult400-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/consult400.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.