how to write expression

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
jenkinsrob
Participant
Posts: 31
Joined: Mon Dec 01, 2003 6:24 am
Location: London

Post by jenkinsrob »

You need two links coming out of your nested condition.

Choose "Custom - Conditional" for the Expression Type and use the following code in the Expression fields

oconv(Date(),"DWA")="SATURDAY" --Link goes to JobS
oconv(Date(),"DWA")="WEDNESDAY" --Link goes to JobW
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

LHS and RHS are metasyntactic variables - placeholders if you prefer. The pseudo-expression LHS=RHS serves only to remind you that whatever expression you use here must be resolvable in a Boolean context - that is, generate a true/false value.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kkreddy
Participant
Posts: 28
Joined: Tue May 10, 2005 6:00 am

Post by kkreddy »

thanks for u r replies and one more
is there any way to test expresion like to see the output of a expression
like this oconv(Date(),"DWA")
jenkinsrob wrote: oconv(Date(),"DWA")="SATURDAY" --Link goes to JobS
oconv(Date(),"DWA")="WEDNESDAY" --Link goes to JobW
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Put it in a server Routine and use the Test button there.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply