Exercise

Using rollbacks

Recently the FFIEC changed the reporting requirement for bank's that provide consumer deposit accounts if they have more than $5,000,000 in brokered deposits. Let's use a transaction to make that update safely. The "Provides Consumer Deposits" flag is in the RCONP752 column and the amount of brokered deposits is in the RCON2365 column.

Instructions 1/2

undefined XP

1
2

BEGIN the transaction.
Update the RCONP752 field to be true if RCON2365 > 5000000.
Undo the mistake.