Re: RPG, SQL and Journaling

Hi Alan,

the table to update has a foreign key constraint?

Another table references to the table to update?

Javier Mora

El mié, 8 may 2024 a las 21:43, Alan Campin (<alan0307d@xxxxxxxxx>)
escribió:

I am working on my next open source project and have run into another
weird one.

I have built a screen program using ILE RPG with SQL for database I/O.
Tables are all defined with DDL. All modules are compiled with
COMIIT(*NONE) and a display of the modules with a DSPMOD show

COMMIT(*NONE)

but when I attempt to do a UPDATE operation on a field in a database

table

the program crashes with an error saying I must have a journal for
commitment control.

I tried adding SET OPTION COMMIT = *NONE but the same result.

I have been writing programs like this for years and never ran into this.
This system is at V7R3.

Has IBM changed RPG to now require that a table be journaled? Nothing I

can

find in the documentation says that.

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.