DAY function in Execute command stage.

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
karry450
Participant
Posts: 201
Joined: Wed Nov 14, 2007 11:31 pm
Location: HYD

DAY function in Execute command stage.

Post by karry450 »

Hi Team,

I want to use the below in Execute command stage


WeekdayFromDate(CurrentDate())<>0
WeekdayFromDate(CurrentDate())<>6 but I cannot do it , Can any one help me with alternate way

Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Why not tell us (in English) what you're trying to achieve? Some information about actual and expected results would also aid us to help you. What you have given does not.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
karry450
Participant
Posts: 201
Joined: Wed Nov 14, 2007 11:31 pm
Location: HYD

Post by karry450 »

I am trying to run a job activity in a sequence , on the weekdays only, I don't want to run on the weekends , i want to implement by writing a trigger in execute command stage .

Can you please help me how to achieve this
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

OK, the functions you used are for the parallel Transformer stage, not available in sequence activities. I would use a Nested Condition activity, with the expression

Code: Select all

Left(Oconv(Date(), "DWB"), 1) <> "S"
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