Transformer Compilation issue on unhandled Nulls

zulfi123786 · Post by **zulfi123786** » Thu May 23, 2013 9:16 am

Hi

This is on V 8.5

The below derivation throws compilation error

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'

However the below compiles fine

Code: Select all

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

chulett · Post by **chulett** » Thu May 23, 2013 9:30 am

Care to share the actual error?

zulfi123786 · Post by **zulfi123786** » Thu May 23, 2013 9:51 am

The error is just pointing to the compiled code.

Code: Select all

##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.

ray.wurlod · Post by **ray.wurlod** » Thu May 23, 2013 4:30 pm

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.

chulett · Post by **chulett** » Thu May 23, 2013 9:19 pm

Pretty sure that was 8.5 but someone else would have to confirm. Or deny.

srinivas.nettalam · Post by **srinivas.nettalam** » Mon May 27, 2013 2:18 pm

Null tolerant stage variables were introduced in v8.5

ray.wurlod · Post by **ray.wurlod** » Mon May 27, 2013 4:38 pm

Or was it 8.5 FP1 ?