Session Ready
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.