Exercise

Working with a single savepoint

Banks that carry large value in Money Market Deposit Accounts (MMDA) are often resilient to downturns in the economy. In order to classify banks, we'll use a flag field such as FIELD48 to store information useful for further processing. Let's flag banks with over 5000000.

Instructions

100 XP

Create a transaction.
Update FIELD48 to MMDA if RCON6810 (MMDA value) is greater than 5000000.
Set a savepoint named mmda_flag_set.
Rollback the whole transaction.