Hi Team,
How to perform RANGE LOOKUP In server job, without using Enterprise or UV stage.
Thanks In Advance
perform Range Lookup in server job
Moderators: chulett, rschirm, roy
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?
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
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: