Siebel Innovation Pack 2015: 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 20 lists the tables containing the data that is modified during unload processing, the macro that performs the modifications, and the relevant upgrade paths.

Table 20. Tables Amended During PRET Unload Processing
PRET Tables Modified During the Table Unload Process	Macro	Siebel Business Applications Paths	Siebel Industry Applications Paths
S_APPL_WEB_TMPL	PTH0062	Not applicable	SIA753
S_APPL_WTMPL_IT	PTH0064	Not applicable	SIA753
S_CONTROL	PTH0222	All Paths	All Paths
S_PCONTROL	PTS0223	HOR753, HOR77	SIA753
S_FN_CRDT_RPT	PTS0224	HOR753, HOR77	SIA753
S_ASGN_RULE_GRP	PTS0225	HOR753, HOR77	SIA753
S_REGION	PTS0227	Not applicable	SIA753
S_REGION	PTS0228	Not applicable	SIA753
S_QTA_OBJCRT_D	PTH0833	All Paths	All Paths
S_ETL_TIME_DAY	PTS0313	Not applicable	SIA753
S_ETL_TIME_DAY	PTS0314	Not applicable	SIA753
S_EXTDATA_TBL	PTS0500	Not applicable	SIA753
S_PAPL_WEB_TMPL	PTS0505	Not applicable	SIA753
S_NOTE_CON	PTM0520	Not applicable	SIA77
S_NOTE_PROD_INT	PTM0520	Not applicable	SIA77
S_NOTE_ACCNT	PTM0520	Not applicable	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.

Siebel Database Upgrade Guide for DB2 for z/OS		Copyright © 2015, Oracle and/or its affiliates. All rights reserved. Legal Notices.