DSXchange

Hi ,

Is there any way can we pass multiples values in Job parameter .

for ex: jprnum="1","4","sa" and use that job parameter to check the input to see if any of the values exists which is input=jprnum and if exists insert , if not reject the record which is input<>jprnum. so if the input is 5 it should reject based on jprnum.

Thanks in advance

Is there any "IN" operator that Datastage supports in order use for the above solution. If not , is there any other functions in Datastage in order to build the above solution

as a work around you can send a cocatenated list of values and then use the function "index" to achieve the same

Thanks for your reply..

Use a concatenated list of values and the Field() function to retrieve the individual values.