The RPG program doesn't give problems at all, and it's a normal RPG source,
not SQLRPG .....

To be able to compile a program with CRTSQLRPG you're forced to include at
least 1 sql statement, say ...
/EXEC SQL
+  SELECT COUNT(*)
+  INTO :X
+  FROM MKTTEC00
/END-EXEC
.............. but the problem is not due to the RPG program .........

The problem raise-up when creating SQL triggers with SQL command like the
following:

create  trigger SNPWARTTST.IT$MITWHL
after insert on MVXBDTA500.MITWHL
referencing NEW as NROW
for each row mode db2sql
begin

[trigger body]

end







                                                                                
                                                          
                      Stan.Schapeler@sande                                      
                                                          
                      n.com                       To:       Consulting on the 
iSeries / AS400 <consult400@xxxxxxxxxxxx>                   
                      Sent by:                    cc:                           
                                                          
                      consult400-bounces@m        Subject:  Re: [Consult400] 
AS/400 SQL Triggers giving CPF4293                           
                      idrange.com                                               
                                                          
                                                                                
                                                          
                                                                                
                                                          
                      04/12/2003 20.36                                          
                                                          
                      Please respond to                                         
                                                          
                      Consulting on the                                         
                                                          
                      iSeries / AS400                                           
                                                          
                                                                                
                                                          
                                                                                
                                                          





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.





_______________________________________________
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.

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.