iif

[fmou]

Hi,

Does DS has the iif or the ? : operator in C?

E.g., I want to build up an output string

part1 : part2 : part3

where part1 & part3 are substring of the input string, and part2 need to be conditionally build according to some specific key char in the input string. The "part2" expressed in C would be

Code: Select all

( condition ? exp1 : exp2 )

how can I do that in DS?

thanks

[stuartjvnorton]

if condition then
part1 : exp1 : part3
else
part1 : exp2 : part3

[chulett]

Code: Select all

part1 : (if condition then exp1 else exp2) : part3 

[fmou]

Code: Select all

part1 : (if condition then exp1 else exp2) : part3 

...

That's the exact answer that I was expecting for.

Thanks a lot chulett

[chulett]

No problem. DataStage doesn't have an "Immediate If" function like Informatica so just stick with classic if-then-else syntax.