how to send multiple values of one column as a parameter

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

Moderators: chulett, rschirm

Post Reply
raghavrhyd
Participant
Posts: 7
Joined: Wed Mar 09, 2011 1:12 am

how to send multiple values of one column as a parameter

Post by raghavrhyd »

Hi,

I would like to send multiple values of one column as a IN parameter to my webservice. Like Severity IN(0,4,5) ,here severity can be 0 OR 4 OR 5.

Pls. advise how i can achieve the same.

Presently i am able to send request and receive reply for one value.

select
0 as severity
from
tab_a

Then webservice_transformer and then target_table as oracle table.

i want it as..

select
0,4,5 as severity
from tab_a (which is not correct)

Pls.advise.

Regds,
Raghav
yammanur.dwhcareer
Participant
Posts: 7
Joined: Sun Apr 10, 2011 11:30 am
Location: Delhi

Re: how to send multiple values of one column as a parameter

Post by yammanur.dwhcareer »

Hi!
You can send anyone of the values(0 or 4 or 5) through a parameter.
Do you want to send all the values at a time?
raghavrhyd
Participant
Posts: 7
Joined: Wed Mar 09, 2011 1:12 am

Re: how to send multiple values of one column as a parameter

Post by raghavrhyd »

i want to send multiple values as parameter to the web service..as my reqmt.is i need to fetch the data where severity IN(0,4,5) and this will be mapped to severity column of receiving system and should receive the corresponding data matching this condition
Post Reply