DSXchange

Hi friends

I am new to Datastage and i am in the process of learning.
My question is can we use a EndIf in the derivation part of Transformer.
For example if i dont have a condition for Else would datastage accept it.

thanks in advance
aakash

No.

The If..Then..Else in an expression is a conditional expression, not a conditional statement. A conditional expression generates one of two values, depending on the result of a test expression. Therefore you must have both a Then clause and an Else clause in an conditional expression.

Further, there is no EndIf in DataStage BASIC. A block of statements introduced by Then or Else as the final token on its line is terminated by an End statement (not an EndIf statement). But this can not be used in an expression, only in a routine.

Thanks a tom Ray

Sorry I mean to Ton Ray

Hi Akaash,

Just in case you are not aware - You can edit your orginal post.

HTH
--Rich