RE: MVC Architecture and transactions

Actually, the same argument can be made for ANY application. If you update
a shop order but don't update the inventory, bad things will happen. The
same holds true for A/R transactions or orders or anything else, really. In
fact, in my experience most business transactions are more than CRUD, and
yet many companies ran fine over the years without commitment control,
primarily because the System i and its DB2 database are so reliable.

If the program is written correctly, the files will get updated. If the
program is not written correctly, commitment control won't help. The only
thing commitment control buys you from a file update capability is when an
I/O error occurs, and frankly, when THAT happens on a System i, you have
much larger problems.

Joe

From: Nathan Andelin

As Aaron points out, a lot of RPG programmers don't do any
COMMIT/ROLLBACK.

If so, they've never worked for a bank. If a customer gives cash to a
teller, you'd better make sure that when you add a record to the
transaction history file, you also update the balance of the person's
account, and update the teller drawer file, and update the general ledger,
and so forth. Otherwise it's going to cause a lot of trouble when someone
tries to figure out why the various account balances and histories are out
of sync.

However, if your application is just basic create, read, update, delete of
single records in a single file, commit/rollback would be over-kill.

Nathan.






__________________________________________________________________________
__________
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail,
news, photos & more.
http://mobile.yahoo.com/go?refer=1GNXIC
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.