Commitment Control Was: Writing from ms SQL to IBM i database (Darryl Freinkel)

Matt,

Commitment control, rollback capability, etc all sound good but think of
this scenario:

You run a large sql update which posts a transaction file into the item
master file. As part of this update it updates the quantity on hand in
the item master.

Item Quantity
X 100
becomes
X 200

Now let's say someone is running some inventory transaction and it updates
the quantity also
X 205

Can you really notice "Aw shucks, I forgot the WHERE clause on my sql
statement. I'll just do a ROLLBACK."? What happens to the quantity of X?
It's not like it changes it from 205 to 105.

I do agree that journalling is important. I argued for it for years. They
put it off until we got Mimix. Now they've gone gonzo with journal
receivers. Not that Mimix requires such retention. The developers just
love the history and tracking so they make sure the retention is long
enough to always span two month ends. (77 days or some such thing).


Rob Berendt