Re: Journal not showing update - DB won't update if nothing has changed?

... I made the same experience, we've made a dummy update under commitment controll, just to get a record lock for synchronisation purposes, we've got the lock, but no journal entry. As we wanted to have an entry (just to help in troubleshooting) we've had to add a flipflop field to get the entries. But it's undocumented and might change with every PTF.

D*B

<Charles>
Been looking into a issue and thought I had a handle on it.

Till I realized for certain records, I don't see an update entry in the
journal as I expected.

Back to the code...after spending a an hour or so looking. I really can't
see how the UPDATE wouldn't have have been hit.

Then it hits me, for a few records, none of the values in the fields of the
file would have actually changed between READ and UPDATE.

IIRC, RPG by design won't actually do an update unless the buffer's changed.

In other words:
read myfile;
wFld1 = fFld1;
wFld2 = fFld2;
fFld1 = wFld1;
fFld2 = wFld2;
update myfileR;

Wound't actually update the record in myfile.

Can anyone confirm that I'm not misremembering?
</Charles>