Changes to the data model for Db2

The following changes were made to the data model for Db2® for 3.2.11.

Tables

The following tables were changed:
  • PAYMENT_SCHEME_TYPE
    • Added “IS RTP"
    • CHAR(1) NOT NULL WITH DEFAULT VALUE Y

Views

The following views were changed:
  • A drop statement was created for VIEW SCHEME_V.

Stored procedures

The following stored procedures were modified:
  • UPSERT_PAYMENT_SCHEME_TYPE considers the new column IS_RTP CHAR.