Dynamic where clause from another table

Dedicated to DataStage and DataStage TX editions featuring IBM<sup>®</sup> Service-Oriented Architectures.

Moderators: chulett, rschirm

Post Reply
aebdw
Premium Member
Premium Member
Posts: 3
Joined: Mon Dec 02, 2013 4:32 pm

Dynamic where clause from another table

Post by aebdw »

Hi,

Is what is noted here possible in a parallel datastage ISD job ? If yes can you please advice how to do that in a ISD job ?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Parameters are bound in when the service is deployed, from what I recall. Of perhaps for one that is not 'always one' it could be when the service is spooled up. For the latter, you could look at building a values file and leveraging that.

However, let's discuss the exact nature of this 'dynamic where clause'. What specifically would be dynamic about it? If it is simply a list of values from a particular field [ where X in (a,b,c,d) ] then a sub-select against a row in a user populated table could be made to work. If the filter columns can change dynamically then AFAIK you'd need to find a way to make a parameter work.
-craig

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