|
midrange.com
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 mailing list archive is Copyright 1997-2025 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.
