Re: SQLRPGLE commit=^none and commit=*chg

<Booth>
Program has 2 sql steps; first, create a file in QTEMP then later a json_table(get_CLOB_from_file). One fails if option is not commit=*none, the other fails if option commit=*none. I can not figure out how to change the commit in between the two sql activities.
</Booth>

several possibilities:

1) you could make your insert/updates to qtemp, specifying a commit option. Something like: insert into qtemp.anyfile .... with NC
2) every actgrp can have a commit level of its own and you could let it run in diffrent pgm/SRVPGM
3.) commit level could be changed by set transaction isolation level, if you are on a transaction boundary. And you could toggle between none and change with
exec sql commit; // end running transaction
exec sql set transaction isolation level ur; // change to commit *CHANGE
// do your commited stuff
exec sql commit; // end transaction
set transaction isolation level nc; // change to commit *NONE
// do some uncommited stuff
exec sql commit;
set transaction ...

My recommendation is: use commit in all your programms and move your qtemp stuff to a SRVPGM with ACTGRP(NOCOMMIT). BTW insert/update/delete with sql and commit *NONE is not state of the art and could have unexpected side effects!!!

D*B