Re: RPG, SQL and Journaling

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Do you have a WITH xxx in the SQL Statement?

UPDATE ...
...
WITH CHG;

That overrides the module setting.

Charles

On Wed, May 8, 2024 at 1:43 PM Alan Campin <alan0307d@xxxxxxxxx> wrote:

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