Between function

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
gayatri
Participant
Posts: 7
Joined: Tue Dec 12, 2006 11:08 am

Between function

Post by gayatri »

Is there any BETWEEN function in datastage like we have in oracle. If not, what can I use for between.
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

No between function. You can use logical operators to do that.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
DeepakCorning
Premium Member
Premium Member
Posts: 503
Joined: Wed Jun 29, 2005 8:14 am

Post by DeepakCorning »

Nope , you will have to use less than and greater than logical operator to achieve it.
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

... or you could create a Between() function. Which would do the same thing internally.

Code: Select all

Ans = (Arg1 >= Arg2 And Arg1 <= Arg3)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”