Upgrade Guide for DB2 UDB for z/OS > Postupgrade Tasks for Applications >

Migrating Course Duration Information for Siebel Training

Upgrades: Releases 7.0.x, 7.5.x.

Environments: Production test, production.

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

When upgrading from a release prior to Release 7.8, course duration information for Siebel Training is not migrated. To display course duration information you must move course duration to an extension column.

To migrate course duration information

1. In Siebel Tools, add an extension column to S_PROD_INT_CRSE. Assign the column the same length and data type as S_SRC_EVT.DURATION_DESC.
2. Use an SQL command to transfer existing course duration data to the extension column.

   The SQL command should have the following form:

   update S_PROD_INT_CRSE a

   set a.<name of new extension column> = (select b.DURATION_DESC from S_SRC_EVT b)

   where a.par_row = b.row_ID)

3. Expose the extension column in the user interface.
4. (Optional.) Create corresponding information in the S_PROD_INT_CRSE.CRSE_HOUR_NUM field.