2213236 - Using OR condition in setRange() function - SAP ESP 5.1

• ESP is being used to convert the following query as a Flex logic using getIterator() and setRange() functions:

select * from W_Employee_Win where empId = xxxxx and deptId in (10,20,30)

• The objective is to do multiple scans, using getIterator().
• The following CCL is implemented:

CREATE FLEX F_EMPLOYEE_DATA
IN I_EmployeeId_Input
OUT OUTPUT W_Employee_Win
SCHEMA Employee
PRIMARY KEY empId
BEGIN
ON I_EmployeeId_Input
{
W_Employee_Win_iterator = getIterator(W_Employee_Win_stream);
setRange(W_Employee_Win_iterator,empId,deptId,I_EmployeeId_Input.empId, .....)

• Is it possible to use setRange() so that the subsequent getnext call returns only those records where empid=xxx and deptid in (10,20,30) ? 

SAP Event Stream Processor (ESP) 5.1

typeof, streaming, processing , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , How To