Upgrade Guide for DB2 UDB for z/OS > Preparing Application Data for Upgrade >

Setting the Value of S_SRC_PAYMENT.TYPE_CD

Upgrades: Release 7.0.x.

All environments. This topic applies to all Siebel environments.

This topic is part of an upgrade process. See How to Perform the Upgrade.

At Release 7.5, S_SRC_PAYMENT.TYPE_CD became a required (NOT NULL) column. If TYPE_CD is null, the value is set to Payment during the upgrade.

Payment indicates that this is a payment from your organization to an external organization. For example, this might denote a payment of marketing funds to your customer.

Before the upgrade, review records where TYPE_CD is null. For those where you do not want the upgrade to set the value of TYPE_CD to Payment, set the value of TYPE_CD.

To set the value of TYPE_CD

1. In S_SRC_PAYMENT, query for records where TYPE_CD is null.
2. For the desired records, use Siebel EIM to set a value for TYPE_CD.

Use the values in the field's LOV.