Upgrade Guide for DB2 UDB for z/OS > Columns Denormalized During Upgrade to Release 7.8 >
Denormalized Columns for 7.5.2 Siebel Industry Applications
Table 55 lists columns that are denormalized during upgrades from Release 7.5.2 Siebel Industry applications to Release 7.8 Siebel Industry applications.
Table 55. Columns Denormalized During Upgrades from Release 7.5.2 Siebel Industry Applications
|
|
|
|
|
S_LOY_MEM_BU
|
MEM_NUM
|
[MEMBER_ID].[MEM_NUM] |
S_LOY_MEMBER
|
MEM_NUM
|
S_LOY_MEM_BU
|
MEM_TYPE_CD
|
[MEMBER_ID].[MEM_TYPE_CD] |
S_LOY_MEMBER
|
MEM_TYPE_CD
|
S_LOY_MEM_PSTN
|
MEM_NUM
|
[MEMBER_ID].[MEM_NUM] |
S_LOY_MEMBER
|
MEM_NUM
|
S_LOY_MEM_PSTN
|
MEM_TYPE_CD
|
[MEMBER_ID].[MEM_TYPE_CD] |
S_LOY_MEMBER
|
MEM_TYPE_CD
|
S_LOY_PROG_BU
|
PROG_NAME
|
[PROG_ID].[NAME] |
S_LOY_PROGRAM
|
NAME
|
S_LOY_PROMO_BU
|
PROMO_NAME
|
[PROMO_ID].[NAME] |
S_LOY_PROMO
|
NAME
|
S_LOY_PROMO_BU
|
PROMO_NUM
|
[PROMO_ID].[PROMO_NUM] |
S_LOY_PRO
|
PROMO_NUM
|
S_LOY_TXN_BU
|
TXN_NUM
|
[TXN_ID].[TXN_NUM] |
S_LOY_TXN
|
TXN_NUM
|
S_LOY_TXN_BU
|
TXN_STATUS_CD
|
[TXN_ID].[STATUS_CD] |
S_LOY_TXN
|
STATUS_CD
|
S_LOY_TXN_BU
|
TXN_SUB_TYPE_ CD
|
[TXN_ID].[SUB_TYPE_CD] |
S_LOY_TXN
|
SUB_TYPE_CD
|
S_LOY_TXN_BU
|
TXN_TYPE_CD
|
[TXN_ID].[TYPE_CD] |
S_LOY_TXN
|
TYPE_CD
|
S_POS_BU
|
POS_NUM
|
[POS_ID].[POS_NUM] |
S_POS
|
POS_NUM
|
S_PROD_STYL_TNT
|
SETUP_STYLE_CD
|
[PROP_STYLE_ID].[SETUP_STYLE_CD] |
S_PROP_STYL_TNT
|
SETUP_STYLE_CD
|
S_PSP_PROC_BU
|
VOD_NAME
|
[VOD_ID].[VOD_NAME] |
S_VOD
|
VOD_NAME
|
S_QUOTE_POSTN
|
QUOTE_NUM
|
[QUOTE_ID].[QUOTE_NUM] |
S_DOC_QUOTE
|
QUOTE_NUM
|
|