Re: CPF4326 in RPGLE program called by SQLRPGLE program

Ok a bit more info.

The SQLRPGLE program is a generic driver that dynamically calls a
specific RPGLE depending on specific criteria.

The RPGLE programs are similar with basically the exact same structure
and use of commitment control.

The SQLRPGLE program may or may not execute a set of SQL statements
(using commitment control) before calling the RPGLE program.

If the SQLRPGLE runs the SQL statements, and calls RPGPGMA, the process works.

If the SQLRPGLE doesn't run any SQL statements, and just calls
RPGPGMB, the process fails with the CPF4326.

It appears that the SQLRPGLE program doesn't actually start commitment
control until the first SQL statement needing commitment control is
run.

Is this working as designed?

Thanks!
Charles Wilt

On Fri, Jan 30, 2009 at 3:29 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

Ok digging into this a bit more:

-------Activation Group--------
Name Number In Use Indicator
*DFTACTGRP 0000000000000001 Yes
*DFTACTGRP 0000000000000002 Yes
QLGLOCAL 0000000000000012 No
17 0000000000000011 Yes
19 0000000000000013 Yes

------Activation Group------ Control
Type Program Name Number Boundary
1 QCMD QSYS *DFTACTGRP 0000000000000001 Yes
RBLDPRCSTG HLTHPRDPGM *NEW 0000000000000011 Yes
RBLDPRCSTG HLTHPRDPGM *NEW 0000000000000011 No
TB100R HLTHPRDPGM *NEW 0000000000000013 Yes
TB100R HLTHPRDPGM *NEW 0000000000000013 No
TG017R HLTHPRDPGM *NEW 0000000000000013 No

TB100R is the SQLRPGLE
TG017R is the RPGLE

Commitment
Opt Definition Text
17 Activation-group-level


Why is the commitment definition under AG#11 when it was created by
the COMMIT(*CHG) on the SQLRPGLE program using AG#13?

Charles


On Fri, Jan 30, 2009 at 3:15 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

The SQLRPGLE is designed to run under *CHG.

Charles

On Fri, Jan 30, 2009 at 2:24 PM, Mark Walter <mwalter@xxxxxxxxxxxxxxx> wrote:

Compile your SQLRPG with COMMIT(*NONE).

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Friday, January 30, 2009 2:02 PM
To: RPG programming on the AS400 / iSeries
Subject: CPF4326 in RPGLE program called by SQLRPGLE program

All,

I'm suddenly ((?)) getting a CPF4326 - Commitment definition *N not
valid for open of FCONTRL0. In an RPGLE program called by a SQLRPGLE
program.

Cause . . . . . : Commitment definition *N is not valid for open of member
FCONTRL0 file FCONTRL0 in library HLTHITGDTA for one of the following
reasons:
-- Member FCONTRL0 was opened for commitment control when commitment
definition *N was not active.
-- Uncommitted changes are pending for member FCONTRL0 for a commitment
definition other than *N.
-- The calling program is using commitment definition *N which has a scope
of *ACTGRP, while the program specified to open the file using a scope of
*JOB.

The SQLRPGLE program specifies DFTACTGRP(*NO) ACTGRP(*NEW)

The RPGLE program specifies DFTACTGRP(*NO) ACTGRP(*CALLER)

Using 16-Display Commitment Control, I see a commit definition with
the text 'Activation-group-level'. There are no changes pending.

From the causes above, I believe the RPGLE is expecting a commit

definition scope of *JOB.

Would you agree?

If so, is there any way to control what commitment scope the RPGLE
program expects?

What I don't understand is why this process has worked in the past
with no issues (and I'm sure there's never been a CL in front with a
STRCMTCTL).

The only thing I can think of that's changed is that the box has been
upgraded from v5r2 to v5r4. It's possible an IBM default value as
been changed from some custom value. But which one?

Thanks in advance!
Charles Wilt
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.