perform Range Lookup in server job

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
palak08
Participant
Posts: 75
Joined: Thu Nov 04, 2010 5:54 pm

perform Range Lookup in server job

Post by palak08 »

Hi Team,

How to perform RANGE LOOKUP In server job, without using Enterprise or UV stage.

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

Post by chulett »

So... based on your 'additional info'... you actually mean how to perform range lookup in a Server job with the DB2 Connector stage?

Now, I don't do DB2 and did not get a chance to use Connector stages but back in the day a 'range lookup' in a Server job with a DB stage meant custom / user-defined SQL. I seem to recall letting the stage generate it and then customizing it to do a BETWEEN or whatever was needed other than the normal equality join.

How about showing us what you've tried and what 'issue' you've had. Anything like what was mentioned above?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Like Craig, I'd use a BETWEEN query in custom SQL. Use two parameter markers and the values coming from two columns marked as Key.
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