IsNull( Trim( ....) ) in Constraint not able to compile
Posted: Thu May 22, 2008 11:28 am
Very simple job. Compiles and runs with IsNull( ...) in constraint (although doesn't give expected results).
When we add the Trim inside the IsNull function, we get the followng error when compiling:
##W IIS-DSEE-TOSH-00049 12:26:13(006) <main_program> Parameter specified but not used in flow: DSPXWorkingDir (DY005_MRG_ECC_CIS.Transformer_50)
Have changed to "IsNull( ...) Or ...=' '" but am wondering why IsNull( Trim( ...) ) isn't working. And whether or not we should go through the hassle of reporting the problem.
Any ideas?
Thanks.
When we add the Trim inside the IsNull function, we get the followng error when compiling:
##W IIS-DSEE-TOSH-00049 12:26:13(006) <main_program> Parameter specified but not used in flow: DSPXWorkingDir (DY005_MRG_ECC_CIS.Transformer_50)
Have changed to "IsNull( ...) Or ...=' '" but am wondering why IsNull( Trim( ...) ) isn't working. And whether or not we should go through the hassle of reporting the problem.
Any ideas?
Thanks.