If svrEarlyStartNullInd=0 AND (MidnightSecondsFromTime(TimestampToTime(LkOutTo_LkUp_Loc.TGT_WRKD_ST_TIME)) < MidnightSecondsFromTime(TimestampToTime(LkOutTo_LkUp_Loc.TGT_MIN_SHFT_ST_TI)))
Then 'Early Start' Else 'T'
If IsNull(LkOutTo_LkUp_Loc.TGT_WRKD_ST_TIME) OR ISNull(LkOutTo_LkUp_Loc.TGT_MIN_SHFT_ST_TI) Then 'R' Else If (MidnightSecondsFromTime(TimestampToTime(LkOutTo_LkUp_Loc.TGT_WRKD_ST_TIME)) < MidnightSecondsFromTime(TimestampToTime(LkOutTo_LkUp_Loc.TGT_MIN_SHFT_ST_TI)))
Then 'Early Start' Else 'T'
I have performed Null Handling in the stage variable and would like to use the first derivation , Not sure why the compilation Error
##W IIS-DSEE-TBLD-00000 10:04:31(009) <main_program> Error when checking composite operator: Output from subprocess: "/projects/ETL/PSA/RT_BP3232.O/V134S22_TEST3_Trans_EXC_DESC.C", line 714.147: 1540-0063 (S) The text ";" is unexpected.
I can't recall whether it was 8.5 or 8.7 that introduced null-tolerant stage variables. If it was 8.7 then this is the underlying cause of your misery, and why the second formulation works.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.