Implementing If ElseIf End Function in DataStage

[srini.dw]

Hi,
How to Implement this in DataStage....
IF B_DT >= PCKG_BEGIN_DT AND B_DT <= FMC_PCKG_END_DT
THEN TYPE := 'N';
ELSIF A_END_DT >= PCKG_BEGIN_DT AND A_END_DT <= FMC_PCKG_END_DT THEN TYPE:= 'R';
ELSE TYPE:='C';


Thanks
Srini

[chulett]

Pretty much just like that, without the assingments and the semi-colons. The TYPE field should be the target of the derivation and use something like this:

Code: Select all

IF B_DT >= PCKG_BEGIN_DT AND B_DT <= FMC_PCKG_END_DT THEN 'N' ELSE IF A_END_DT >= PCKG_BEGIN_DT AND A_END_DT <= FMC_PCKG_END_DT THEN 'R' ELSE 'C'

Your dates would also need to be in a 'comparable' format, ISO compliant: YYYY-MM-DD.

[ray.wurlod]

Note that ELSE IF is two words - there is no ELSEIF or ELIF operator. Note also that this is a value-generating expression, not a statement in a function, so that assigment operators and statement terminators are inappropriate.

[Ragupathy]

Pretty much just like that, without the assingments and the semi-colons. The TYPE field should be the target of the derivation and use something like this:

Code: Select all

IF B_DT >= PCKG_BEGIN_DT AND B_D ...[/quote]


we can give like this

  if 1=1 then 100 else  if 1=2 then  200  else 0

[Ragupathy]

Pretty much just like that, without the assingments and the semi-colons. The TYPE field should be the target of the derivation and use something like this:

Code: Select all

IF B_DT >= PCKG_BEGIN_DT AND B_D ...[/quote]


we can give like this

  if 1=1 then 100 else  if 1=2 then  200  else 0

[Sainath.Srinivasan]

we can give like this

if 1=1 then 100 else if 1=2 then 200 else 0

The result in this case will always be 100.

Btw, this thread was initiated and resolved more than 2 years ago. The poster might have moved on to new adventures.