Siebel Database Upgrade Guide for DB2 UDB for z/OS > Siebel Upgrade Files >
Tables Amended During PRET Unload Processing
The unload job control cards for specific tables have been modified so that during PRET (pre-table) processing, the data in the tables is modified during the table unload process instead of being modified after the data has been loaded into the target table. Table 33 lists the source tables containing the data that is modified during unload processing, the macro that performs the modifications, and the relevant upgrade paths.
Table 33. Tables Amended During PRET Unload Processing
PRET Tables Modified During the Table Unload Process |
|
|
|
S_APPL_WEB_TMPL |
PTH0062 |
HOR704 |
SIA704, SIA752 |
S_APPL_WTMPL_IT |
PTH0064 |
HOR704 |
SIA704, SIA752 |
S_POSTN_CON |
PTS0100 |
n/a |
SIA704 (FINS704 only) |
S_CONTROL |
PTH0222 |
All (except SG704) |
All |
S_PCONTROL |
PTS0223 |
HOR752, HOR77 |
SIA752 |
S_FN_CRDT_RPT |
PTS0224 |
HOR752, HOR77 |
SIA752 |
S_ASGN_RULE_GRP |
PTS0225 |
HOR752, HOR77 |
SIA752 |
S_REGION |
PTS0227 |
n/a |
SIA 704 (FINS704 only), SIA752 |
S_REGION |
PTS0228 |
n/a |
SIA752 |
S_ENTLMNT_ITEM_FEE |
PTS0270 |
n/a |
SIS704 |
S_ENTLMNT_ITEM_FEE |
PTS0271 |
n/a |
SIS704 |
S_CURRCLM_PER |
PTH0289 |
HOR621 |
SIA621, SIS63 |
S_EVT_ACT |
PTH0405 |
HOR621 |
SIA621, SIS63 |
S_QTA_OBJCRT |
PTH0832 |
HOR621 |
SIA621, SIS63 |
S_QTA_OBJCRT_D |
PTH0833 |
All and SG704 |
All |
S_WF_PROC_FLOW |
PTH1003 |
HOR621, HOR704 |
SIA621, SIS63, SIA704 , SG704 |
S_WF_STEP |
PTH1006 |
HOR621, HOR704 |
SIA621, SIS63, SIA704, SG704 |
S_ASSET_POSTN |
PTS0301 |
n/a |
SIS 704 only |
S_ASSET_POSTN |
PTS0302 |
n/a |
SIS 704 only |
S_ASSET_POSTN |
PTS0303 |
n/a |
SIS 704 only |
S_ASSET_POSTN |
PTS0304 |
n/a |
SIS 704 only |
S_ETL_TIME_DAY |
PTS0313 |
n/a |
SIA752 |
S_ETL_TIME_DAY |
PTS0314 |
n/a |
SIA752 |
S_DD_MEAS_ATTR |
PTS0350 |
n/a |
SIS63 |
S_CON_ADDR_U1 |
PTM0410 |
n/a |
SIA621, SIS63, SIA704 |
S_EXTDATA_TBL |
PTS0500 |
n/a |
SIA752 |
S_PAPL_WEB_TMPL |
PTS0505 |
n/a |
SIA752 |
S_NOTE_CON |
PTM0520 |
n/a |
SIA77 |
S_NOTE_PROD_INT |
PTM0520 |
n/a |
SIA77 |
S_NOTE_ACCNT |
PTM0520 |
n/a |
SIA77 |
S_DOCK_TXN_LOG |
PTM0010 |
All Paths |
All Paths |
S_ESCL_REQ |
PTM0010 |
All Paths |
All Paths |
NOTE: Unload and load jobs on tables that contain CLOB data are processed by the PTMCLOBx macros. These macros adjust the unload and load job control cards to handle any CLOB data in a table. The PTMCLOBx macros can be found in the DSNHLQ.SIEBEL.EXEC or in the VSTG0300 and the VSTG0310 staging data sets.
|