DSXchange

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

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?

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