Trace Flag 2

Setting the Trace Flags parameter to 2 creates a file log that traces all substitutions of user parameters. The following example shows an EIM Trace Flag 2 output:

[TRC01] Parameter Set << AFTER RESOLUTION >> 
[TRC01]   UserParams = IFTABLE=EIM_ACCOUNT 
[TRC01]  [0] $IFTABLE = EIM_ACCOUNT 
[TRC01]  [1] $CURRENT_USER = wgong 
[TRC01]  [2] $CURRENT_DATETIME = 4/6/01 13:17 
[TRC01] [Siebel Integration Manager] 
[TRC01] log transactions = false
[TRC01] $COLUMN_VALUE = 'EIM ins_acct Test%'
[TRC01] [ins_acct_shell] 
[TRC01] TYPE = SHELL
[TRC01] INCLUDE = del_acct
[TRC01] INCLUDE = ins_acct
[TRC01] [del_acct] 
[TRC01] SESSIONSQL = DELETE FROM DEV50.EIM_ACCOUNT WHERE IF_ROW_BATCH_NUM=21
[TRC01] TYPE = DELETE
[TRC01] BATCH = 20
[TRC01] TABLE = EIM_ACCOUNT
[TRC01] $COLUMN_NAME = NAME
[TRC01] DELETE MATCHES = EIM_ACCOUNT,(NAME LIKE 'EIM ins_acct Test%')
[TRC01] [ins_acct] 
[TRC01] SESSIONSQL = INSERT INTO DEV50.EIM_ACCOUNT (IF_ROW_STAT, ROW_ID, 
IF_ROW_BATCH_NUM, ACCNT_NAME, ACCNT_LOC) SELECT 'X', ROW_ID, 21, 'EIM ins_acct Test 
' || ROW_ID, 'Loc' FROM DEV50.S_SYS_PREF
[TRC01] TYPE = IMPORT
[TRC01] BATCH = 21
[TRC01] TABLE = EIM_ACCOUNT