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 ?
Dynamic where clause from another table
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.
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
"You can never have too many knives" -- Logan Nine Fingers