Display the long name of the day

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

rajeevm
Participant
Posts: 135
Joined: Sun Jan 22, 2006 10:44 am

Post by rajeevm »

I resolved it by using stage variable .I created a stagevariable for weekdayfromdate(Issue_Dt) Then used in the derivation as If stagevar=0 and edition_cd ='01' then B:Route_Id else Route_Id

So it worked.

Thanks for all your help I appreciate it.

rajeev
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That's a "best practice" for things like this - the stage variable does the evaluation of the expression once and then you leverage it multiple times. This also means there's only one place to change if the rules change, not "n" number of places... and maybe you miss one. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply