Re: RPG, SQL and Journaling

[datil400 <datil400@xxxxxxxxx>]

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.