Job Parameter

rsunny · Post by **rsunny** » Wed Apr 20, 2011 7:38 am

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

rsunny · Post by **rsunny** » Wed Apr 20, 2011 8:18 am

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

zulfi123786 · Post by **zulfi123786** » Wed Apr 20, 2011 8:30 am

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

rsunny · Post by **rsunny** » Wed Apr 20, 2011 8:44 am

Thanks for your reply..

ray.wurlod · Post by **ray.wurlod** » Wed Apr 20, 2011 4:18 pm

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