Re: AS/400 SQL Triggers giving CPF4293

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.