Integration

Problem Summary

---------------------------------------------------

ALDSP: Generate a SQL "IN" clause

Problem Description

---------------------------------------------------

I would like to know if there is a possibility of generating an SQL "IN" clause using ALDSP.

I would need the XQuery construct to create an SQLsomething like-

select * from emp where dept_no in ('101', '201', '301');

The values for dept_no would be passed at runtime.

(Or)

Will be I able to create a physical data service using the SQL - select * from emp where dept_no in ?

If yes, how do I map the parameter to "?"

Thanks.