Transformer lookup on ODBC reference links

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
syedmuhammedmehdi
Participant
Posts: 43
Joined: Wed Feb 12, 2014 12:34 pm
Location: Hyderabad, India

Transformer lookup on ODBC reference links

Post by syedmuhammedmehdi »

Hi, I'm converting a server job to parallel job. In server job a file is read and using transformer stage a lookup is done on DB using ODBC stage. My query is if there are multiple records in DB for an input record whether multiple records will be output or any random sigle lookup will be done and only one record will be the output?
SyedMuhammadMehdi
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

That's an option for ODBC (and UV), there is a "Return multi-row result set" checkbox on the link, from what I recall.
-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 »

Why aren't you converting to use the Lookup stage for lookups?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

I'm assuming they are but wanted some clarification as to how they work on the Server side.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply